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

​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    Read More

​