looking up zipcodes from another workbook

Hi all,

I have a set of zipcodes that I need to find the neighborhoods for in one workbook. In another workbook, I have zipcodes and their corresponding neighborhoods. I used this formula in the first workbook: =VLOOKUP(A2,[Book1]Sheet1!$A:$B,1,FALSE)

What am I doing wrong?

EDIT: I added the file, added the second workbook as the second tab.

Easier if you could post the file to look at.

But I've stopped using Vlookup's and using an Index Match instead, which IMO is a better method.

Here is good tutorial on it.
http://www.randomwok.com/excel/how-to-use-index-match/

Wait. I just realized your trying to do compare to another workbook, not a worksheet in the same workbook. Index/Match should still work, but if you have the sample files it could be easier to look at.

I also did a quick test and this formula, which looks same as yours works with both files open.

=VLOOKUP(C2,[Book2]Sheet1!$B:$C,2)

In book2 Column 1 has the ZipCode and Column 2 is the Neighborhood.

Using your example file and creating a Book1 this formula works. Your formula was missing the file extensions.

Formula:

Please Login or Register  to view this content.