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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose Indirect formula 2
VBA for Dependents shortcut menu 0
Using the INDIRECT function across multiple worksheets 0
Indirect? 2
Help with Address(), Indirect(), Offset 2
INDIRECT Function 9
COUNTIF + ADDRESS Issue 1
Vlookup and return sheet name also 2

Top