Forum Discussion
faraujo
4 years agoRegular Visitor
Extract a Record Value with a Variable Field
Hello,
This is the Record cell that is driving me crazy:
The first column (4) is variable, it can be from 1 to 11. So I want to add a new column just showing the 2nd column (3).
When I use this lookup formula I obviously get the number 3 because I insert in lookup field the number 4.
How can I solve this problem, extracting the correct answer whatever the number in the left column is?
Thanks a lot!
Thank you mate! It returns the "4" instead of the "3" (as I would prefer) but I can make some adjustments to extract the "3" number. Thanks!