VLOOKUP Failing for some random values

[renanpoco]

Hi, i'm trying to apply =vlookup for the spreadsheet attached to look for portuguese translations into sheet1 ("original ptbr") and retrieve them into sheet2 ("match translation") but it is failing for some random values and i don't know why since the words and the translations are there.

Here is the spreadsheet:
https://www.dropbox.com/s/vfu7jl0ea...he original portuguese ulpan course.xlsx?dl=0

Does anyone know how to fix this?

Thanks,
Renan

 

[Fluff]

Some of the values on the "Match" sheet have extra spaces, hence it not a match.

 

[renanpoco]

Some of the values on the "Match" sheet have extra spaces, hence it not a match.

what is the easier way to fix it as a whole ? i mean, to remove all those random and useless extra spaces. Thanks

 

[Fluff]

In I2 put
=Trim(c2)
and fill down, then change the Vlookup to look at col I

 

[renanpoco]

In I2 put
=Trim(c2)
and fill down, then change the Vlookup to look at col I

I did that, it fixed a bunch of values but it is still failing for others as you can see:

https://www.dropbox.com/s/vfu7jl0ea...he original portuguese ulpan course.xlsx?dl=0

 

[Fluff]

You need to fix the look up range like
=VLOOKUP(I2,'ORIGINAL PTBR'!C$2:D$1814,2,FALSE)
otherwise when you copy it down it will change to C3:D1815 for row 3 etc.

 

[renanpoco]

You need to fix the look up range like
=VLOOKUP(I2,'ORIGINAL PTBR'!C$2:D$1814,2,FALSE)
otherwise when you copy it down it will change to C3:D1815 for row 3 etc.

Now it is perfect! Thank you vm

 

[Fluff]

Glad to help & thanks for the feedback