| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect woksheet and keep using outline capabilities | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| How do I Increment a particular woksheet number? | Excel Worksheet Functions | |||
| Sound / Audible Alert in a Woksheet ? | Excel Worksheet Functions | |||
| on exel how do I can take out the ceros on the woksheet? | Excel Worksheet Functions | |||
Linear Mode
