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...
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) )