LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect woksheet and keep using outline capabilities Jean-Luc Excel Discussion (Misc queries) 1 September 28th 09 01:27 PM
Get Cell Address From Lookup (Alternative to Lookup) ryguy7272 Excel Worksheet Functions 12 September 28th 07 10:36 PM
How do I Increment a particular woksheet number? [email protected] Excel Worksheet Functions 2 March 6th 06 02:36 AM
Sound / Audible Alert in a Woksheet ? carl Excel Worksheet Functions 3 July 7th 05 09:17 PM
on exel how do I can take out the ceros on the woksheet? ana ibarra Excel Worksheet Functions 1 May 25th 05 09:47 AM


All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"