Formula to find Effective Date in a Table

[03856me]

ColumnA	ColumnB	ColumnC
EffDate	Dept	Uptime%
02/01/12	Sawmill	85%
02/01/12	Planer	83%
05/01/12	Sawmill	86%
06/01/12	Planer	84%
07/01/12	Sawmill	86.5%
07/01/12	Planer	84.5%

<TBODY>
</TBODY>

I have a table (uptimeTable) setup as above to capture Goals for uptime percentages.

My report is on a different worksheet and the user enters the date for the report, say 08/10/12 - in the sawmill section 86.5% should populate and in the planer 84.5% should.

Likewise if the user enters 05/31/12 - the sawmill would be 86%, the planer would be 83%

I have tried several formulas but cannot get the values to show up. Could someone point me in the right direction please?

 

[Skybluekid]

EffDate</SPAN>	Dept</SPAN>	Uptime%</SPAN>
02/01/2012</SPAN>	Sawmill</SPAN>	85%</SPAN>
02/01/2012</SPAN>	Planer</SPAN>	83%</SPAN>
05/01/2012</SPAN>	Sawmill</SPAN>	86%</SPAN>
06/01/2012</SPAN>	Planer</SPAN>	84%</SPAN>
07/01/2012</SPAN>	Sawmill</SPAN>	86.50%</SPAN>
07/01/2012</SPAN>	Planer</SPAN>	84.50%</SPAN>
Date</SPAN>	Sawmill</SPAN>	Planer</SPAN>
02/01/2012</SPAN>	0.85</SPAN>	0.83</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

Going on your columns try: =INDEX($C$3:$C$8,MATCH($B$12&C11,$B$3:$B$8&$C$3:$C$8,0)) with Ctrl + Shft + Enter under Sawmill and =INDEX($C$3:$C$8,MATCH($B$12&D11,$B$3:$B$8&$D$3:$D$8,0)) with Ctrl + Shft + Enter under Planer