Forum Discussion
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 se...
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.