dkim18
asked on
Is there a simple way to find and replace in excel?
Hi,
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.
Thanks much.
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.
Thanks much.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER