Forum Discussion

colineversden's avatar
colineversden
Copper Contributor
Nov 04, 2024

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

 

 

office 365

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 04, 2024

    colineversden 

    =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.