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.
dkim18Asked:
Who is Participating?
 
jppintoCommented:
You can use VLookup function, like the attached file.

jppinto
Q24342306.xls
0
 
dkim18Author Commented:
Excellent.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.