The VLOOKUP works as intended. The XLOOKUP is giving "#NAME" error:
screenshot of the formula:
the working VLOOKUP:
=VLOOKUP(C12,B24:C29,2,FALSE)
Which I'm reading as "take the value from c12", look at the table B24:C29, lookup the second column.
the not functional XLOOKUP:
=XLOOKUP(C11,B24:B29,C24:C29)
which I'm reading as:
lookup the value in C11, Find the value in the range B24:B29, return the corresponding value in C24:C29.
Possibly I've made a typo, but maybe I'm not understanding the XLOOKUP function sufficiently.
Primarily I'm using Microsoft Co-Pilot and then also reading tutorials.
I'll use the Markdown editor, but a copy paste of data:
Client Name SKU Item Name
McGowan 294211 =XLOOKUP(C11,B24:B29,C24:C29)
Grossman 327064 =VLOOKUP(C12,B24:C29,2,FALSE)
Chamberlain 446741
Vong 643081
Williams 294211
Hicks 446741
Singh 306862
Zach 643081
Li 446741
Totals
SKU Description Price
294211 Leather sectional 1399
306862 Entertainment center 809.99
327064 Media cabinet 379.99
446229 Suede recliner 1099.99
446741 End table set 467.99
643081 Dining table 599.99
=XLOOKUP(
in cell shows up then its supported else not, unless you have some addins. Also, if you gotoFormulas
Tab Ribbon and click onLookup & Reference
you will get to see the function. Highly suggested to readMSFT
documentations.#NAME?
error can appear --> here