Lookup across multiple spreadsheets
 

Hi, I was wondering if it is possible to auto grab and insert data (via
Lookup??) between two different spreadsheets (in different folders)

eg,
Grab data from Cell A1 in "C:\Excel01\Spreadsheet01.xls"
and place into Cell B1 in "C:\Excel02\Spreadsheet02.xls"

Any help would be a life saver!

Thanks


--
Rob76
------------------------------------------------------------------------
Rob76's Profile: http://www.excelforum.com/member.php...o&userid=34167
View this thread: http://www.excelforum.com/showthread...hreadid=539308

Lookup across multiple spreadsheets
 

Something like

=VLOOKUP(A1,'C:\Documents and Settings\Martin\My
Documents\[Book2.xls]Sheet1'!$A$1:$B$1,2,0)

should do the trick.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=539308