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.