Forum Discussion
Solved
XLookup with Structured Table References
I can't find anything that directly speaks to this, so I'll post here. I have a table of individuals with some columns of information. It's defined as as a table. I have another table where I ...
Bert Onstott If those are real names and info, please delete and only supply phony informations.
As for what is happening is the '@' which is saying look only at this specific row. So change it to this and it seems to work fine:
=XLOOKUP([@Name],MasterlistTable[Name],MasterlistTable[Phone 1],"error")so now it looks at the Name in this table on THIS (@) line, but searches the entire MasterlistTable[Name] instead of only 1 row of that table.
Bert Onstott If those are real names and info, please delete and only supply phony informations.
As for what is happening is the '@' which is saying look only at this specific row. So change it to this and it seems to work fine:
=XLOOKUP([@Name],MasterlistTable[Name],MasterlistTable[Phone 1],"error")so now it looks at the Name in this table on THIS (@) line, but searches the entire MasterlistTable[Name] instead of only 1 row of that table.
Thank you so much!!! I am new to using XLOOKUP and did not know about this @ symbol for table structure. This saved me!!