Index or V-Lookup Formula needed

[Morgenweg]

I have an MRP excel spread sheet and I am trying to match a part number with a date but the dates in the tab I want to pull from are listed in a column not a row and they have to be in the column. This is the formula I have but it will not work. =INDEX(BUILDS!$D$1:$I$5000,MATCH($B52,BUILDS!$D:$D,0),MATCH(L$4,BUILDS!$F$1:$F$5000,0))

Any ideas? Let me know if you need more of an explanation, I tried to added photos but it would not work.

Steven

 

[Special-K99]

FYI, you cant attach files on this forum.

You can however upload the file to a storage site and post a link to it on the forum

 

[Thondar]

Try this - =INDEX(Sheet2!A12:J15,MATCH($B17,Sheet2!$A12:$A15,0),MATCH($D17,Sheet2!$B$11:$J$11,0)+1)

Where the data is on Sheet 2 from A12 to J15 and the part number to look up is I cell B17 and the Date to look up is in D17.

Start at row A11
[TABLE="width: 870"]
<tbody>[TR]
[TD]

[/TD]
[TD="align: right"]11/1/2017[/TD]
[TD="align: right"]11/2/2017[/TD]
[TD="align: right"]11/3/2017[/TD]
[TD="align: right"]11/4/2017[/TD]
[TD="align: right"]11/5/2017[/TD]
[TD="align: right"]11/6/2017[/TD]
[TD="align: right"]11/7/2017[/TD]
[TD="align: right"]11/8/2017[/TD]
[TD="align: right"]11/9/2017[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD] 60.00 [/TD]
[TD] 12.00 [/TD]
[TD] 9.00 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 32.00 [/TD]
[TD] 10.00 [/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] 30.00 [/TD]
[TD] 65.00 [/TD]
[TD] 5.00 [/TD]
[TD][/TD]
[TD] 6.00 [/TD]
[TD][/TD]
[TD][/TD]
[TD] 18.00 [/TD]
[TD] 1.00 [/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] 40.00 [/TD]
[TD][/TD]
[TD] - [/TD]
[TD][/TD]
[TD] 8.00 [/TD]
[TD][/TD]
[TD][/TD]
[TD] 6.00 [/TD]
[TD] 2.00 [/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] 1,000.00 [/TD]
[TD] 1.00 [/TD]
[TD] 3.00 [/TD]
[TD][/TD]
[TD][/TD]
[TD] 120.00 [/TD]
[TD] 500.00 [/TD]
[TD] 2,000.00 [/TD]
[TD] 400.00 [/TD]
[/TR]
</tbody><colgroup><col><col><col><col span="6"><col></colgroup>[/TABLE]