MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vary sheet name in vlookup formula

Posted by Steve on September 14, 2001 8:09 PM

I have this formula in B13:

=VLOOKUP(A10,'Master Employee'!A5:O1003,3,FALSE)

I need to be able to change the sheet name to whatever is in cell B7 on my sheet. Can someone tell me how to do that?

Thanks in advance

Posted by Aladin Akyurek on September 15, 2001 1:38 AM


In B7 enter: Master Employee

In B13 enter: =VLOOKUP(A10,INDIRECT("'"&B7&"'!A5:O1003"),3,0)

Note 1. The last arg is a zero which means the same thing as FALSE.
Note 2. The formula assumes the same layout in all input worksheets.



Posted by Steve on September 15, 2001 6:58 AM

Thanks Aladin,

Your formula worked great!