Vlookup and sheet name

[BC]

Looking for some help,
I have Multiple Sheets all named with people names
I have a master sheet with this formula
=IF($A2="","",VLOOKUP($C$1,Bozo!$D$14:$K$236,8,FALSE))
works great except I need to change the sheet name all the time "Bozo" to
the different sheet names.
The sheet name is already on this same sheet in Cell A2 But
=IF($A2="","",VLOOKUP($C$1,A2!$D$14:$K$236,8,FALSE))
Does not work.
Sorry if this is a silly question, im new to excel and Ive been searching
for days triyng to find the answer, Thanks for the help BC

 

[carlo]

What you need is the indirect formula:

=IF($A2="","",VLOOKUP($C$1,indirect(A2 & "!$D$14:$K$236",8,FALSE))

hth

Carlo

 

[BC]

Thank you Carlo for the reply, I tryed your formula and I get a you entered
too many arguments for this fuction error.

 

[carlo]

Hey BC

sorry, my mistake, forgot to close the brackets:

=IF($A2="","",VLOOKUP($C$1,indirect(A2 & "!$D$14:$K$236"),8,FALSE))

 

[Dave Peterson]

Sometimes, worksheet names have to be surrounded by apostrophes (embedded
spaces, numbers, names that look like addresses):

=IF($A2="","",VLOOKUP($C$1,indirect("'" & A2 & "'!$D$14:$K$236"),8,FALSE))

 

[carlo]

Thanks for pointing that out Dave, totally forgot to include that!!!

Carlo

 

[BC]

Thank you for the help! Works great! BC

Thanks for pointing that out Dave, totally forgot to include that!!!

Carlo