# Help with Match Function

#### lluke

##### New Member
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
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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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))

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

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

Many, Many, Thanks!!

Replies
3
Views
125
Replies
6
Views
343
Replies
5
Views
228
Replies
7
Views
135
Replies
1
Views
183

1,207,094
Messages
6,076,547
Members
446,212
Latest member
KJAYPAL200

### 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?

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