What you need is the VLOOKUP function
-----Original Message-----

I have two worksheets. Worksheet A is the file I'm
currently entering
data into. Worksheet B is completed and features every
zip code in the
US in column 1 and the closest large city corresponding
to each zip code
in column 7. I have the zip codes (which I am entering
into column 1 of
Wksheet A), but have to search (Ctrl+F) Wksheet B with
each zip code, go
to the found zip code, scroll over 6 columns, copy the
city name, then
paste that into column 2 of Wksheet A. I am hoping
there's a way to
make a macro for this, but can't figure out how to make
it work with a
different zip code every time. Can anyone figure this
out??? I have
2,000 of these to do and going back and forth is killing
me,
literally.

If it's helpful, what I've been doing is
1)entering a zip code into col.1 of Wksheet A
2)copy that zip
3)activate Wksheet B and Ctrl+F to bring up Find feature
4)paste zip code into Find feature and hit enter
5)go to designated row with correct zip, then find the
corresponding
city (same row as "found zip", but in column 7)
6)copy the corresponding city out of col. 7 of Wksheet B
7)Activate Wksheet A and paste the city name into col.2
of Wksheet A

Row after row of this is making me nuts...


--
NWill
----------------------------------------------------------
--------------
NWill's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14668
View this thread:
http://www.excelforum.com/showthread...hreadid=262867

.