I have this table of products: [image] I have the Project Address populated in a select list using this formula so that the only options in the select list are addresses associated with that client: [Project Locations].Filter(Client=thisRow.Client) Default value is set to use the first, and usua…

@Bianca_Adams See if anything in this doc helps you out.

Thank you so much!! Worked perfect. Is this how you would explain it? Formula for Column B in Table 1 (just the parts in bold): ThisRow.Column A Name from Table 1(the column that is pulling in data from Column C in Table 2 and acting as the filter for Column B from Table 1).Column A Name From Tab…

Lookup column based on value of a select list from a lookup

Superhuman Ask the Community

Ander March 7, 2019, 1:10am 4

@Bianca_Adams

Read @mallika’s comment here: Return data from fields in same row after lookup

Topic		Replies	Views
Filter a list based on matching the corresponding info in another column Ask the Community	3	3178	February 20, 2019
Need help - Lookup or Selectlist + Filter Ask the Community	2	472	September 5, 2019
How to create a column where its List Values update, based on another column Ask the Community	6	647	March 16, 2023
How to Filter Table Values by Column Name (in Formulas) Ask the Community	12	2699	September 2, 2020
Same table lookup? Ask the Community	3	867	August 15, 2019

Lookup column based on value of a select list from a lookup

Related topics