Hello,
I'm using 365.
I actually have a different spreadsheet that I would greatly appreciate having help with.
Please see attached file: XLOOKUP
How can XLOOKUP be used in B2:B5 and C2:C5 to lookup which vendor & department in the Data tab are associated with the order number? The green shaded cells in the XLOOKUP Data tab are what I want returned using XLOOKUP.
Any help would be greatly appreciated.
Thank you,
Karen
|