Forum Discussion

DnGr's avatar
DnGr
Copper Contributor
Dec 30, 2024

Formula

I am trying to create a ticket/invoice that grabs information from multiple sheets within the same file.  I used =XLOOKUP(B19,Table1,1,0), however the formula wont pull up the information from the second sheet.  I used name manager.  

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    You would need to first stack the tables with VSTACK, pull out the lookup and return arrays, and then perform the XLOOKUP. If you have a sample workbook a formula can be drawn up. Also, the syntax of your XLOOKUP seems to be written for a VLOOKUP.

  • Fedrickson's avatar
    Fedrickson
    Copper Contributor

    i was also finding it difficult and got assisted by xiaospy1 on tiktok.

  • Please explain in detail how you want to retrieve information from multiple sheets.

Resources