| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in another sheet? | Excel Worksheet Functions | |||
| Vlookup on more than one sheet | Excel Worksheet Functions | |||
| VBA and use vlookup from one sheet to copy data from another sheet | Excel Programming | |||
| vlookup across more than one sheet | Excel Worksheet Functions | |||
| VLOOKUP from another sheet, VBA | Excel Worksheet Functions | |||
Hybrid Mode
