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
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