Vlookup and sheet name
Thank you for the help! Works great! BC
"carlo" wrote:
Thanks for pointing that out Dave, totally forgot to include that!!!
Carlo
On Jan 16, 9:32 am, Dave Peterson wrote:
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 wrote:
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 -
--
Dave Peterson- Hide quoted text -
- Show quoted text -
|