I have received price list from suppliers, when I try to vlookup it does not work, I format into general and do everything you should od but it wont work.

I noticed that there numbers are on a different side, so if I double click on there part number, it moves to the other side and there you go, the vlookup number appears.

As you can imagine, I can get it to work if I double click on every number from the supplier, but when you have 3,000 or more numbers it would take some time.

Can anyone help me?