Indirect function refer to other workbook

T

Tang

Dear all

I am looking for a function like "indirect" that able to to refer to a cell
in other workbook.

Eg Cell A1 in ABC.xls Sheet 1 is "Good", then the function should work like:
=indirect('[ABC.xls]Sheet1'A1) will give me the result "Good".

regards
Tang
 
J

Jerry W. Lewis

=INDIRECT("'[ABC.xls]Sheet1'!A1")
works just fine, provided that ABC.xls is open. Indirect takes a string
argument. The single quotes do not hurt, but are only needed if there
are spaces in either the workbook or worksheet name.

Jerry
 
Top