Extract a Record Value with a Variable Field

[faraujo]

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!

[lbendlin]

Use Record.FieldNames(<record name>){0}

[faraujo · Accepted solution]

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!