Excel Get Data Problem

[je8259]

I want a cell to return the value on a tab named whatever is on the ro
I am trying to retrieve data for. Kind of like a VLOOKUP, bu
referencing a variable tab name and fixed cell.
For example if I have a sheet named [Summary] and in column A o
[Summary] there are values such as peoples names (e.g. John, Mark, etc
- assume that the names would be unique). I want cell B1 to see tha
cell A1 = Mark and therefore return the value that is on the "Mark" ta
in cell $P$4.

I have had mixed results trying different methods, but have not bee
able to make it all come together.

Thanks for any help you can provide

 

[Debra Dalgleish]

Use the Indirect function:

=INDIRECT("'"&A1&"'!$P$4")

I want a cell to return the value on a tab named whatever is on the row
I am trying to retrieve data for. Kind of like a VLOOKUP, but
referencing a variable tab name and fixed cell.
For example if I have a sheet named [Summary] and in column A of
[Summary] there are values such as peoples names (e.g. John, Mark, etc.
- assume that the names would be unique). I want cell B1 to see that
cell A1 = Mark and therefore return the value that is on the "Mark" tab
in cell $P$4.

I have had mixed results trying different methods, but have not been
able to make it all come together.

Thanks for any help you can provide.

 

[je8259]

Worked Great! I had been playing @ w/ INDIRECT, but didn't think t
concatenate my sheet name. Thanks for your help