VLOOKUP not working for whole data in column

[luca85]

Hi all,

attached you can see a workbook where:

- left tab has a list of company codes and their countries in the near column
- right tab has same company codes, their score and another column where I tried to do a vlookup so that I can see the countries there too.

Unfortunately this vlookup only worked for a portion of the column, possibly because pulling the formula down, the area covered by it changes. How can this be fixed?

Thanks in advance

Luca

[JohnTopley]

Try

=VLOOKUP(A2,'C:\Users\Owner\Downloads\[Scores.xlsm]CompanyRegionLookup'!$A$2:$B$51,2,FALSE)

This range needs to be ABSOLUTE

[luca85]

That's what I thought...thank you!