|
Vlookup and sheet name
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 - |
Vlookup and sheet name
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 |
Vlookup and sheet name
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 - |
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 - |
| All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com