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…

Hi Everyone any good tricks out there that can be used to do the above ? Thank you so much

How do you make doc public without requiring guest to ask for permission to accesss the doc ? I only know how to give access only when i know the person’s email address Apologies @Steve_Yang

@M_Hermi Embed [image] [image] [image]

Thanks Paul for your help ! Appreciate all your contribution in this community

Combining 2 different Columns from 2 different tables in a Lookup

Superhuman Ask the Community

Steve_Yang May 4, 2020, 9:40am 5

@M_Hermi Embed

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 Ask the Community	5	1550	March 22, 2021
Select lists as table with multiple columns Ask the Community	7	3029	January 16, 2021
Retrieve all selectable items from a list column Ask the Community	3	1581	December 29, 2018
Lookup from Table vs Selectable List Ask the Community	12	4138	March 20, 2019
Reference individual cell data in another table Ask the Community	2	3142	August 6, 2019

Combining 2 different Columns from 2 different tables in a Lookup

Related topics