Hey Community, I would like to do a lookup from 2 different columns in 2 different tables. So that when i add a new data inside the Incoming Letter Table i can select the From Column from both Suppliers and Clients. Thanks in Advance

To answer your question — you can make a select list and write a formula for your list options that will combine items from two tables: [image] Depending on your needs, this may or may not be a good solution. Since this column now may contain items of not the same type (items from Suppliers and i…

Combining 2 different Columns from 2 different tables in a Lookup

Steve_Yang May 4, 2020, 9:40am 5

@M_Hermi Embed

1 Like

No help needed - Just a question to ask about : Concatenate() a list of sequential and/or non-sequential numbers?

Topic		Replies	Views
Lookup for multiple tables	5	1520	March 22, 2021
Select lists as table with multiple columns	7	2970	January 16, 2021
Retrieve all selectable items from a list column	3	1559	December 29, 2018
Lookup from Table vs Selectable List	12	4022	March 20, 2019
Reference individual cell data in another table	2	3104	August 6, 2019

Combining 2 different Columns from 2 different tables in a Lookup

Related topics