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