Solved: Lookup a value that exists eiter in one table or a... - Page 2

khuslid · 03-25-2020 10:53 AM

Hi folks.
I’m sure this is easy, but I searched and cannot solve it.
I want to lookup a name in my table1, and find a matching email that either exists in table2, table3 or table4.
It is because I have 3 different tables with companies (one for each type of company). The matching name is of course in one of the 3 different tables, but i need to search for it in all three. No REF is used here.
Suggestions?

Aleksi

For example…
INDEX(
LIST(LOOKUP([_THISROW].[Name],“Table2”,“NameColumn”,“EmailColumn”))+
LIST(LOOKUP([_THISROW].[Name],“Table3”,“NameColumn”,“EmailColumn”))+
LIST(LOOKUP([_THISROW].[Name],“Table4”,“NameColumn”,“EmailColumn”))
,1)

View solution in original post

Lookup a value that exists eiter in one table or another table