Link to home
Start Free TrialLog in
Avatar of dkim18
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.
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dkim18
dkim18

ASKER

Excellent.