problem with VLOOKUP

Dear Community,

I have a problem when using VLOOKUP. I copy pasted countries and their codes. I want Excel to order the codes in the different table. I used a formula:

=VLOOKUP(A234;$E$226:$F$464;2;FALSE)

It didn't find all codes even though they are in the second table. I see errors. I attached a sample of my Excel file

Some of the entries in column A have trailing spaces, so they do not produce an exact match with your lookup table. You can correct this by using this formula in B2:

=VLOOKUP(TRIM(A2);$E$226:$F$464;2;FALSE)

then copy it down.

Hope this helps.

Pete

Thank you for your kind help!

Glad to help - thanks for the rep.

Pete