| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search & return items by ws name
Hello,
I have a worksheet named Summary which contains the names of every worksheet in the workbook (stored in column A). WorkSheet called "Summary": Cell A2 = 1001 A3 = 1002 A4 = 1003... A126 Worksheet called "1001": Cell A4 = 1001 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN Worksheet called "1002": Cell A4 = 1002 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN I would like to find a way to use a formula to return Employee Name and Employee SSN from the individual workbooks to the Summary worksheet based off the worksheet name and Column A of Summary worksheet. -- Thank You! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search & return items by ws name
Try this in your Summary Sheet:
=INDIRECT(A2&"!B4") This will give you the Employee Name from the Sheet whose name is stored in cell A2. Replace B4 with C4 to get the SSN. HTH, Elkar "maijiuli" wrote: Hello, I have a worksheet named Summary which contains the names of every worksheet in the workbook (stored in column A). WorkSheet called "Summary": Cell A2 = 1001 A3 = 1002 A4 = 1003... A126 Worksheet called "1001": Cell A4 = 1001 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN Worksheet called "1002": Cell A4 = 1002 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN I would like to find a way to use a formula to return Employee Name and Employee SSN from the individual workbooks to the Summary worksheet based off the worksheet name and Column A of Summary worksheet. -- Thank You! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search & return items by ws name
You're a genius!
-- Thank You! "Elkar" wrote: Try this in your Summary Sheet: =INDIRECT(A2&"!B4") This will give you the Employee Name from the Sheet whose name is stored in cell A2. Replace B4 with C4 to get the SSN. HTH, Elkar "maijiuli" wrote: Hello, I have a worksheet named Summary which contains the names of every worksheet in the workbook (stored in column A). WorkSheet called "Summary": Cell A2 = 1001 A3 = 1002 A4 = 1003... A126 Worksheet called "1001": Cell A4 = 1001 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN Worksheet called "1002": Cell A4 = 1002 (AKA worksheet name) Cell B4 = Employee Name Cell C4 = SSN I would like to find a way to use a formula to return Employee Name and Employee SSN from the individual workbooks to the Summary worksheet based off the worksheet name and Column A of Summary worksheet. -- Thank You! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to search for multiple items at the same time? | Excel Discussion (Misc queries) | |||
| Search for value on another sheet, return Y/N | Excel Discussion (Misc queries) | |||
| Search for data in a column bring all related items in other colum | New Users to Excel | |||
| Search and return | Excel Worksheet Functions | |||
| Can a VLOOKUP use two items to search | Excel Worksheet Functions | |||
Linear Mode
