Actually, this may work with the second workbook closed - does in 2007.
Somedays I remember things wrong.

"TXDalessandros" wrote:

I have two spreadsheets that have the following in column A and B
Address TripCode
4137 BOARDMAN-CANFIELD RD AK003

I need to look up the value from SS 1 Column A(ADDRESS) in another
spreadsheet (the same value is in spreadsheet 2 column j) and return The
TripCode (SS 1 COL b from that address into SS2 COLUMN b IS THIS POSSIBLE
WITH THE VLOOKUP FUNCTION?

THANK YOU!!!