Forum Discussion
Solved
Getting useful data from another table
The file I am working with has data from one table with an ID number (ctp), then on another data set I have the same ID numbers (ID) with their location names(name). What I'm trying to do is have the...
Have you tried creating a calculated column using the LOOKUPVALUE function?
Location =LOOKUPVALUE(table2[address],table2[ID],table1[ctp])
