Help Converting Formula

[Anne Troy]

I need to have this formula use the file name in column A (A2, for now) to get the file number (name).
I can't get rid of the "(3)" part right now.

Thanks in advance!!!

='[90602.xls]Page 1 (3)'!$B$10

 

[6StringJazzer]

This will answer your question but you will get an error if the referenced file is not open. A macro is required to either populate the formula, or open the referenced file.

=INDIRECT("'[" & A2 & ".xls]Page 1 (3)'!$B$10")

 

[Anne Troy]

Got it. Thanks!!!!