I hope some one can help.

Basically we have a sheet on our excel file with part numbers in column a and then corresponding image file names in column b.

On a separate sheet in the same excel file we have over 90,000 products.

What we would like to do is create a formula that can search for the part number on the second sheet and then input the image file name next to it from the other sheet.

I was successful in doing this HOWEVER the formula I used only worked on part numbers which were only numbers and approximately 90% of our 90,000 products are alphanumeric ie DA1991. Can anyone help with writing the formula which would locate the correct part number for each file name for both numeric part numbers and alpha numeric part numbers?

Any help is appreciated.

Thanks