Lookup Returning Values From Non-Display Columns

Hello!

I have a table that I want to run multiple lookups against from formulas in Automations, with each lookup returning a value from a different column. The problem is, whenever I run the lookup formula it only returns the value in the column that is marked as the display column. Is there any way to target non-display columns to return values from?

Thanks

Here is an example. So if I have a lookup table and I want to target other columns to return values from, how would I do that?

Notice that the lookup formula is only returning values from the Payee column (marked as Display) but how would I modify the formula to return, for example, the Group or the Category belonging to Payee = Comcast ?

Thank you!

@fatherofinvention

Would dot access work for you, like this?

Lookup(Categories,Payee,"Bestbuy").Category

2 Likes

Does the below make sense?

3 Likes

Elegant in its brevity and simplicity! Works perfect, thank you @Ander

1 Like

Excellent visual aid, thank you very much @Jean_Pierre_Traets!

1 Like

Edit: thanks for the help you guys!