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!

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!

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!