Vlookup and zip codes

[Trojnfn]

ok, another vlookup problem. Sheet 1 contains numerous zip codes. Sheet 2 contains unique zip codes and cities. I want to use vlookup to populate sheet 1 with cities from sheet 2 using the zip codes. The problem is that only zip codes with zeros in fron work, like 01801 (Woburn, MA). All other zip codes doe not work and return #N/A. I tried to make all the zip codes text, general, numeric, and zip code but it still does not work. How do I get this to work using vlookup? I also searched the internet for help and they suggested I used index/match. I h ave never used those functions before and tried to follow their examples but cannot get it to work. If vlookup works, how can I get it to work? If index/match is better, can someone explain to me how it works and give and example base on my sheet 1 and 2? Just when I thought I understand vlookup, index/match comes along and adds to my confusion.

[JBeaucaire]

The problem will be in the data, something isn't what it looks like.

Attach your sample workbook so we can look for ourselves at your two sheets.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Danerida]

Try:
=INDEX(Sheet2_Table_zipcodes_&_cities_e.g._A1:B2000,MATCH(Sheet1_zipcode_to_lookup_e.g._A5,Sheet2_zipcodes_e.g._A1:A2000,0),2) -- the "2" assumes your cities are in the second column of the range "Sheet2_Table_zipcodes_&_cities_e.g._A1:B2000"

You should make sure that the ranges all have the same number of rows.

Hopefully this is clear for you.

Dan