Forum Discussion
DnGr
Dec 30, 2024Copper Contributor
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.
- Patrick2788Silver 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.
- FedricksonCopper 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.