Lookup Returning Values From Non-Display Columns

1

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

2

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!

3

@fatherofinvention

Would dot access work for you, like this?

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

3 Likes
4

Does the below make sense?

image
image.png1270×1070 56.3 KB

4 Likes
5

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

1 Like
6

Excellent visual aid, thank you very much @Jean_Pierre_Traets!

1 Like
7

Edit: thanks for the help you guys!