excel issue, vlookup?

[lamaar75]

I have a spreadsheet that has a list of building, their location and country. This spreadsheet has about 12000 entries. Have of teh entries for the country column are missing.

If need a way of looking up a location in a columns, assigning a country to that location and then putting the relevant country code in the cell.

What is the best way to do this. I have tried and tried but my only option at the moment is to do it manually.

Thanks

 

[plettieri]

Hi:


Have you tried looking at the auto filter technique?

plettieri