Lookup to a non-display column

[Hannah_Krumholz]

Hello!

Does anyone know if it’s possible to look up a non-display column? I want to be able to lookup values in two separate columns in a table, but can only currently do a lookup for the display.

Any workarounds?

Thanks!
Hannah

[Christiaan_Huizer]

hi @Hannah_Krumholz , happily it is via chaining.

you take the name of the column that contains the lookup value, you add a dot and you see the options you need.

Cheers, Christiaan

[Hannah_Krumholz]

This will make it a formula rather than a select list though right?

For more context, I have a list of accounts and contact details - I need the account to be the display column, but I also want a select list of all contacts that we have.

[Christiaan_Huizer]

maybe this post helps:

Lookup Formula with two values

Hello @Hannah_Krumholz! As @Christiaan_Huizer noted, you could change the lookup to a Filter() as it gives you more flexibility. But you don’t really need a lookup nor a Filter formula in your case, as in the Column 1 you are pulling the Companies rows directly so you can get the Contacts directly from the Company Row as it follows: [Column 1].Contacts.ListCombine()

the moment you share a doc with a concrete example, plenty of people are willing to help you out, cheers,Christiaan