Use cell value as workbook name in vlookup range

[sat-65]

I have the following formula that works. However, I would like to automatically change a portion of it depending on the cell value.
Let's say in cell A1 the user types in "IS 12-19-13" I would like to change the workbook name "IS 12-18-13" in the formula.

=IFERROR(VLOOKUP(BQ17,'[IS 12-18-13.xlsm]Summary'!$B$3:$D$21,3,FALSE),0)

Is this possible?

[Olly]

First: poor thread title. Most threads in this subforum need help with formula. Be a little more specific in future.

Now, to your problem: yes, it's possible. Use:

=IFERROR(VLOOKUP(BQ17,INDIRECT("'["&A1&".xlsm]Summary'!$B$3:$D$21"),3,FALSE),0)

[sat-65]

Sorry for the poor thread title. This is my first time here. I will be more specific with my upcomming posts.

Thank you for your help with my formula issue.

[vlady]

Moderator's Note:
I change your title that describe your problem.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Regards,
Vladimir