Forum Discussion

Bert Onstott's avatar
Bert Onstott
Copper Contributor
Aug 08, 2020
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 ...
excel
Formulas and Functions
office 365
  • mtarler's avatar
    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's avatar
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.

  • allison3145's avatar
    allison3145
    Copper Contributor
    Oct 15, 2021
    Thank you so much!!! I am new to using XLOOKUP and did not know about this @ symbol for table structure. This saved me!!
  • Bert Onstott's avatar
    Bert Onstott
    Copper Contributor
    Aug 11, 2020

    Thanks, that worked!

Resources