Hi JorgeAE,

When you refer to different spreadsheets I hope you mean different
worksheets in the same file (workbook). This is relatively
straight-forward. If you want to lookup values in a different workbook
based on codes, this is possible using the indirect and vlookup
functions IF both files are open. However I'd recommend avoiding this
if at all possible and combining the files into one workbook.

Here's how to do the lookup across different worksheets:

http://contextures.com/xlFunctions02.html


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534035