Lookup between two books

  • Thread starter Thread starter CSmith
  • Start date Start date
C

CSmith

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!
 
Try this in K2:

=VLOOKUP(H2,'[Book B.xls]Sheet1'!B:D,3,0)

Copy down as required. This assumes Book B is open - if not then you
will need to have the full path between the first apostrophe and the
[.

If you get #N/A errors, this means there is no exact match. If you
think that there are matches, then you might have the 5-digit code in
column H as a number and the codes in Book B as text, or vice versa.

Hope this helps.

Pete
 
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
 
Back
Top