LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
MR
 
Posts: n/a
Default Lookup Lookup Lookup

Here is how my workbook looks -

It has 7 sheets named Summary, 2000, 2001, 2002, 2003 etc
In each sheet, there are 12 rows with headings - Jan, Feb, Mar etc
In each sheet, there are 7 columns with headings - NA, EMEA, AP etc

In the Summary Sheet, I need to pull up the value for, say 2002, Mar, EMEA.
However, these values (2002, Mar and EMEA) are entered by the user in cells
B1,B2 and B3. (I do not want to hardcode the values).

Can anyone tell me how to do this? I tried MATCH function, but it does not
accept a variable value for the sheet name. Other functions have similar
issues.

Thanks!!
 
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
How to create a lookup table with an added varable? GIZZMO Excel Worksheet Functions 3 April 6th 09 10:32 PM
Lookup Function Problem seve Excel Discussion (Misc queries) 9 February 28th 05 02:46 AM
Lookup function w/Text and Year Josh O. Excel Worksheet Functions 1 February 12th 05 11:27 PM
Excel Lookup Functions Paul Adams Excel Worksheet Functions 1 November 10th 04 02:40 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 08:41 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"