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

	11/1/2017	11/2/2017	11/3/2017	11/4/2017	11/5/2017	11/6/2017	11/7/2017	11/8/2017	11/9/2017
1		60.00	12.00	9.00				32.00	10.00
2	30.00	65.00	5.00		6.00			18.00	1.00
3	40.00		-		8.00			6.00	2.00
4	1,000.00	1.00	3.00			120.00	500.00	2,000.00	400.00

<tbody>
</tbody><colgroup><col><col><col><col span="6"><col></colgroup>