Forum Discussion
LOOKUP QUERY
I have a problem with a lookup table whereby we have a series of part numbers all starting with the same numeric value but then end with a different alpha numeric value. When we run the Lookup it wont return a value:
=LOOKUP(B14,Data!A5:A404,Data!E5:E404)*AN5
=XLOOKUP(B14, Data!A5:A404, Data!E5:E404, "Not Found") * AN5
XLOOKUP is more flexible and doesn’t require the data to be sorted, plus it allows for an exact match lookup, which would suit part numbers with similar starting digits.
NikolinoDE That works fine thankyou.
