Help with Match Function

lluke

New Member
Joined
Jun 29, 2004
Messages
33
I have two worksheets in the same work book

Sheet one looks like:
Capacity for Capacity Planner_083106 (2).xls
ABCDEFGHI
2LCStyle09/01/200609/08/200609/15/200609/22/200609/29/200610/06/2006
3B1GS003811.6%
4B1GS009876.7%
5B1GS016911.7%
6B2GS00369.9%
7B2GS009982.5%
8B2GS01687.5%
9B3GS000797.7%
10B3GS13452.3%
11B4GS001999.0%
12B4GS13461.0%
13B6GS0448100.0%
14B7GS0449100.0%
15B8GS011616.9%
16B8GS087583.1%
Sheet1


Sheet two looks like this:
Capacity for Capacity Planner_083106 (2).xls
BCDEFGH
1LoadCategory09/01/200609/08/200609/15/200609/22/200609/29/200610/06/2006
2B1909090909070
3B2250250250250250200
4B3140140112140140140
5B4500500400500500500
6F200000
7F300000
8F500000
9F800100115115100
10H1185018501480165216521480
11H11700700700700700700
12H2150150120150150150
cross tab


I would like to have a formula to use on sheet one column d which will return the value the LC and Date intersection.

Can anyone help??

Many Thanks!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
D3 on Sheet1, copied across and down:

=INDEX('cross tab'!$C$2:$H$12,MATCH($A3,'cross tab'!$B$2:$B$12,0),MATCH(D$2,'cross tab'!$C$1:$H$1,1))
 
Upvote 0
Does this do it:
Book3
ABCDEFGHI
1LCStyle9/1/20069/8/20069/15/20069/22/20069/29/200610/6/2006
2B1GS003811.60%909090909070
Sheet1


Formula is: =INDEX(Sheet2!$B$2:$G$12,MATCH($A2,Sheet2!$A$2:$A$12,0),MATCH(D$1,Sheet2!$B$1:$G$1,0))

HTH,

Smitty
 
Upvote 0
Thanks!!! This works perfectly. I am amazed by everyone's expertise.

Many, Many, Thanks!!
 
Upvote 0

Forum statistics

Threads
1,226,287
Messages
6,190,065
Members
453,592
Latest member
bcexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top