Hi,

Something like this will work

=VLOOKUP(H3,[Book1]Sheet1!$B$1:$H$100,3,FALSE)

Adjust as needed. You should open both workbook, choose Window, Arrange,
Tile and build the formula by pointing and clicking.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"CSmith" wrote:

I have 2 seperate books, not tabs within a book. In Book A, column H is a
column of short 5 digit numeric codes in each cell. Keeping within Book A, I
need my formula to be in column K, where my return result will be. I need a
formula that will look at cell H2 (or whatever cell it is as I copy and paste
the formula down the column), and then go to Book B and search for that code
in column B. Once it finds that specific code in column B in Book B, staying
in the same row, I need it to grab the zip code associated with it in column
D and put that zip code back in Book A, cell K2. This is all in Excel 2007
and if I need to, I can put Book B as a tab within Book A, but would prefer
not to do so. Thanks for any help you can give!