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 ...

excel

Formulas and Functions

office 365

mtarler
Aug 08, 2020
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.

mtarler

Silver Contributor

Aug 08, 2020

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

Copper Contributor

Aug 11, 2020

Thanks, that worked!

Forum Discussion

XLookup with Structured Table References

Resources