View Single Post
  #4   Report Post  
Old January 11th 13, 01:16 AM
ricklongbow ricklongbow is offline
Junior Member
First recorded activity by ExcelBanter: Jan 2013
Posts: 5

Originally Posted by ricklongbow View Post
Thank you very much. I'm not sure I understand the syntax as I'm a bit new at this. With these actual parameters what would the formula be?

Sheet B (named ZIP_CODES) - 5 digit zips are in cells A2:42742. Ascending sort. Counties are D2:42742

Sheet A (named emergency contacts) 5 digit zips are in N2:2709. Ascending sort. I want to return couties into Q2:2709.

Sheet A actually extends out to CP. Where would I insert the formula? And how do I execute it once copied in?

Pardon my needs for beginners explaination but that is what I am ! Thank you very much.

I am afraid I was not sufficiently precise asking the initial question. Let me restate it. My apologies

I have two single sheet workbooks (seperate files) "contactsexport12282012" and "ZIP_CODES" in Outlook 2010. Both contain columns of five digit zip code values (contactsexport12282012 N2-2675 and ZIP_CODES A2-42742). ZIP_CODES also contains the coordinating county names in F2-42742.

For each contact (row) in contactsexport12282012 I want to lookup the same zip in ZIP_CODES and import the county name into contactsexport12282012 P2-2675 (empty column).

The full filenames a C:\Users\Rick\Desktop\ZIP_CODES C:\DATA\contactsexport12282012.

NOTE - Would it be helpful if I temporarily copy the ZIP_CODES data onto the contactsexport12282012 sheet??

I'm not trying to learn how (right now) as I am short on time. I also need instruction on where to put it and how to execute it. Like I said, I'm a newbie. Thank you very much.