Is there a simple way to find and replace in excel?
Posted on 2009-04-21
I have two worksheets in excel workbook.
ws1 has country, city,type, lat, long
ws2 has country,city,lat, long
I am trying to fill in ws1's lat & long values.
I want to look for ws2's city and find it in ws1 then take ws2's lat & long values and enter them in ws1 lat and long.
Does this make sense?
I have about 2000 records in ws1
I filter out country and city in ws1 for the duplicates in ws1 and listed in ws2 to find the lat and long. Now I want to fill ws1's lat and long.