Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search worksheet names?
Is there a way to search through a workbook by first finding a certain
worksheet, then running a vlookup in that worksheet? EG: Sheets1~Sheet5 I want to find sheet2, and in sheet2, run vlookup. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search worksheet names?
You can do this programmatically. Code similar to the following will help
you find the sheet you are looking for: For each sht in thisworkbook.sheets if sht.name = strCriteria then 'Can return sheet name to a function here. end if next -- http://HelpExcel.com "J@Y" wrote: Is there a way to search through a workbook by first finding a certain worksheet, then running a vlookup in that worksheet? EG: Sheets1~Sheet5 I want to find sheet2, and in sheet2, run vlookup. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search worksheet names?
What exactly do you mean by "finding" a certain sheet, and by "running" a
VLOOKUP? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "J@Y" wrote in message ... Is there a way to search through a workbook by first finding a certain worksheet, then running a vlookup in that worksheet? EG: Sheets1~Sheet5 I want to find sheet2, and in sheet2, run vlookup. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search worksheet names?
I'm not very familiar with codes. Can you elaborate abit on what exactly is
needed? Will this code be executed as a macro or can I embed it in the cells? "galimi" wrote: You can do this programmatically. Code similar to the following will help you find the sheet you are looking for: For each sht in thisworkbook.sheets if sht.name = strCriteria then 'Can return sheet name to a function here. end if next -- http://HelpExcel.com "J@Y" wrote: Is there a way to search through a workbook by first finding a certain worksheet, then running a vlookup in that worksheet? EG: Sheets1~Sheet5 I want to find sheet2, and in sheet2, run vlookup. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search worksheet names?
Well here is the equation I use right now to vlookup in multiple sheets in a
workbook: =VLOOKUP(A2,INDIRECT("'"&INDEX({"Sheet1";"Sheet2"; "Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Shee t8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3"; "Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A 2:A200"),A2)0),0))&"'!A2:C200"),2,0) But that runs into problems when the sheets contain the same words being looked up. So I'm thinking if there is a way to search for a Sheet name, and then in that Sheet, perform a vlookup. "Chip Pearson" wrote: What exactly do you mean by "finding" a certain sheet, and by "running" a VLOOKUP? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "J@Y" wrote in message ... Is there a way to search through a workbook by first finding a certain worksheet, then running a vlookup in that worksheet? EG: Sheets1~Sheet5 I want to find sheet2, and in sheet2, run vlookup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can vlookup be used to search in more than one worksheet? | Excel Worksheet Functions | |||
How to sort Worksheet names? | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Lookups using worksheet names | Excel Discussion (Misc queries) | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) |