Hi everyone

I have the following problem. I would like to do a VLOOKUP since I have a list with parts in one file. And a list with parts and reference numbers in another list. I would like to associate the reference numbers to the parts in the first list.

The part numbers have the following format: 1234 AAA

Problem is: The part numbers may vary at the end. You would have ABA when the part was slightly altered. BAA would be a completetly new development of the part. Thus I would lose my match.

Therefore, I would have to search first for the exact part number and then reduce to search for 1234 AA and if there is no match saerch for 1234 A. Of course since the can also be sveral hits for 1234 A like 1234 AAA or 1234 ABA e.g. I would have to display all hits.

Anyone know how to do this?

Thank you for your help!