Forum Discussion
Using Xlookup function from a separate sheet
Just recently acquired Office 365 in order to use the Xlookup function and still not able to bring over the data from a separate sheet. In the sample spreadsheet I'm wanting to bring over the qty from a master PO list using the part # and PO #. Is this possible? These are the (2) tabs in the sample spreadsheet.
Tab A
Tab B
Thanks!
Practically the same as Riny_van_Eekelen suggested, but with XLOOKUP only
=XLOOKUP( $A3, B!$A$3:$A$5, XLOOKUP(B$2, B!$B$2:$D$2, B!$B$3:$D$5) )Paul_Step650 XLOOKUP doesn't allow you to combine row headers and column headers into a single lookup value, lookup array or return array.
Perhaps the attached file clarifies how you should approach your problem, though it's not particularly pretty. Note that I have deliberately changed the order of the columns in sheet A.
- Thank you very much!
