Forum Discussion

faraujo's avatar
faraujo
Regular Visitor
4 years ago
Solved

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!

  • faraujo's avatar
    faraujo
    4 years ago

    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!

2 Replies

    • faraujo's avatar
      faraujo
      Regular Visitor

      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!