Are you really using XL2021 or rather 365? The latter has many lookup functions that will spill

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Attached Files

XLOOKUP.xlsx (14.2 KB, 4 views)

MS 365 is not an option in the drop-down. That's why I chose 2021.