Hi,
I'm most likely going about this the wrong way... but here goes:
Is there a way to select a column in a table based on a criteria and use this in a lookup formula?
I have a Table set ut as shown below, and I use a LookUp formula to select the appropriate record for my app. The Columns named '100', '200',... etc represent the material properties of the material for a given temperature i.e. 100 F, 200 F, etc.
Referencing a field using LookUp is fairly easy when the column name is known. for example:
LookUp(Table; Material = MatrDropdown.Selected.Value; '100')
but....I want to grab the temperature from an TextInput box (TempBox) and when I try to parse it into the lookup formula it no longer returns the field from the table but the actual input from the textinput box.
Here's what I've tried:
LookUp(Table; Material = MatrDropdown.Selected.Value; Value(TempBox.Text))
I.e. if I put 100 as value in the textinputbox, then the value 100 is returned and not the referenced to the field in Table.'100' that corresponds to the selected material. I've tried adding "" or '' to the value, or simly renaming the columns to XXX, YYY, ZZZ etc but the same problem persists. Is there another/better way to reference a column in a table?
| Material | 100 | 200 | 300 | 400 | 500 | 600 |
| CS- A106 B / API 5L B | 20,00 | 20,00 | 20,00 | 20,00 | 18,90 | 17,30 |
| CS- A333 Gr.6 | 20,00 | 20,00 | 20,00 | 20,00 | 18,90 | 17,30 |
| CS- A671 C60/ A672 CC60 | 20,00 | 19,50 | 18,90 | 18,70 | 17,30 | 15,80 |
| CS- API 5L X52 | 22,00 | 22,00 | 22,00 | 22,00 | 0,00 | 0,00 |
| CS- A671 C70 | 23,30 | 23,10 | 22,50 | 21,70 | 20,50 | 18,70 |
Kind Regards
-Bjørn
