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 fro...
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!