HLOOKUP - Horizontal lookup

Ask for Help
1

Hello, the function is still in development, how can you dynamically substitute a value from a column in Lookup? If the column name is selected from the dropdown list.

2

Hi @BiBo.

Could you explain what you mean by “dynamically substitute a value from a column in Lookup”? Is something like the following example what you were looking for?

People.lookupOne(Email=$Work_Email)

George

3

Thank you for response.
Example in Grist
Something similar to selecting values ​​from a matrix.

4

I think getattr is what you’re looking for.

Here’s an example of a formula that I believe produces the results you’re expecting:

record = Table2.lookupOne(id=$Selector)

getattr(record, $Selector.Column)

George

1 Like
5

It works! Although I don’t understand how it works.