Hey BC

sorry, my mistake, forgot to close the brackets:

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

On Jan 15, 9:46*pm, BC wrote:
Thank you Carlo for the reply, I tryed your formula and I get a you entered
too many arguments for this fuction error.



"carlo" wrote:
What you need is the indirect formula:

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

hth

Carlo

On Jan 15, 10:42 am, BC wrote:
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,FAL SE))
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- Hide quoted text -

- Show quoted text -