lookup a cell on another woksheet by using the tab name
 

I have 95 worksheets. Each one has been named.

I have a list of these same names on my summary sheet.

I want to lookup a cell on the worksheet that matches my summary cell details.

Thus my summary list has Paul Peter John Adam

I have worksheets for Paul Peter john Adam

I want my summary sheet cell d3 to show the value of cell r88 on worksheet
Adam under the Adam column of my summary sheet

lookup a cell on another woksheet by using the tab name
 

If adam is in A4, you could use:

=indirect("'" & a4 & "'!r88")

Debra Dalgleish has some notes about =indirect():
http://contextures.com/xlFunctions05.html

noseyg wrote:

I have 95 worksheets. Each one has been named.

I have a list of these same names on my summary sheet.

I want to lookup a cell on the worksheet that matches my summary cell details.

Thus my summary list has Paul Peter John Adam

I have worksheets for Paul Peter john Adam

I want my summary sheet cell d3 to show the value of cell r88 on worksheet
Adam under the Adam column of my summary sheet

--

Dave Peterson

lookup a cell on another woksheet by using the tab name
 

tHANK yOU VERRY VERY MUCH. I HAVE BEEN LOOKING FOR THAT FOR ABOUT 5 YEARS.

THANK YOU VERY MUCH DAVE

"Dave Peterson" wrote:

If adam is in A4, you could use:

=indirect("'" & a4 & "'!r88")

Debra Dalgleish has some notes about =indirect():
http://contextures.com/xlFunctions05.html

noseyg wrote:

I have 95 worksheets. Each one has been named.

I have a list of these same names on my summary sheet.

I want to lookup a cell on the worksheet that matches my summary cell details.

Thus my summary list has Paul Peter John Adam

I have worksheets for Paul Peter john Adam

I want my summary sheet cell d3 to show the value of cell r88 on worksheet
Adam under the Adam column of my summary sheet

--

Dave Peterson