In Excel2007, I need a formula that will lookup an item in another file, find it and then give me the cell contents 3 rows up and 1 over to the right. For example...

file 1...

today 50
yesterday 100
tomorrow 200
xyz

today 20
yesterday 200
tomorrow 400
abc


file 2...
formula to lookup "xyz" and then give me today's amount = 50. the captions are in one column and the amounts in the next column. Thanks