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!