CODEWITHSUNDEEP
excelexcel-formulamatchlookup
TropicalMagic
TropicalMagic

Reputation: 126

Excel - Lookup Value

I am unable to return a lookup value, obtaining either #VALUE! or #N/A! error.

Here is the screenshot of worksheet layout: enter image description here

Question: How do I return the "HONOURS" value in cell N3?

Many thanks!

Upvotes: 0

Views: 40

Answers (1)

Harun24hr
Harun24hr

Reputation: 36780

Try below XLOOKUP() formula. Here match_mode 1 will search for exact match or next larger item in array.

=XLOOKUP(L3,$F$3:$F$8,$G$3:$G$8,"",1)

enter image description here

Upvotes: 1

Related Questions