Formula to find Effective Date in a Table

[03856me]

[TABLE="class: grid, width: 100, align: left"]
<TBODY>[TR]
[TD]ColumnA
[/TD]
[TD]ColumnB
[/TD]
[TD]ColumnC
[/TD]
[/TR]
[TR]
[TD]EffDate
[/TD]
[TD]Dept
[/TD]
[TD]Uptime%
[/TD]
[/TR]
[TR]
[TD]02/01/12
[/TD]
[TD]Sawmill
[/TD]
[TD]85%
[/TD]
[/TR]
[TR]
[TD]02/01/12
[/TD]
[TD]Planer
[/TD]
[TD]83%
[/TD]
[/TR]
[TR]
[TD]05/01/12
[/TD]
[TD]Sawmill
[/TD]
[TD]86%
[/TD]
[/TR]
[TR]
[TD]06/01/12
[/TD]
[TD]Planer
[/TD]
[TD]84%
[/TD]
[/TR]
[TR]
[TD]07/01/12
[/TD]
[TD]Sawmill
[/TD]
[TD]86.5%
[/TD]
[/TR]
[TR]
[TD]07/01/12
[/TD]
[TD]Planer
[/TD]
[TD]84.5%
[/TD]
[/TR]
</TBODY>[/TABLE]

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]

[TABLE="width: 301"]
<TBODY>[TR]
[TD]EffDate</SPAN>[/TD]
[TD]Dept</SPAN>[/TD]
[TD]Uptime%</SPAN>[/TD]
[/TR]
[TR]
[TD]02/01/2012</SPAN>[/TD]
[TD]Sawmill</SPAN>[/TD]
[TD]85%</SPAN>[/TD]
[/TR]
[TR]
[TD]02/01/2012</SPAN>[/TD]
[TD]Planer</SPAN>[/TD]
[TD]83%</SPAN>[/TD]
[/TR]
[TR]
[TD]05/01/2012</SPAN>[/TD]
[TD]Sawmill</SPAN>[/TD]
[TD]86%</SPAN>[/TD]
[/TR]
[TR]
[TD]06/01/2012</SPAN>[/TD]
[TD]Planer</SPAN>[/TD]
[TD]84%</SPAN>[/TD]
[/TR]
[TR]
[TD]07/01/2012</SPAN>[/TD]
[TD]Sawmill</SPAN>[/TD]
[TD]86.50%</SPAN>[/TD]
[/TR]
[TR]
[TD]07/01/2012</SPAN>[/TD]
[TD]Planer</SPAN>[/TD]
[TD]84.50%</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date</SPAN>[/TD]
[TD]Sawmill</SPAN>[/TD]
[TD]Planer</SPAN>[/TD]
[/TR]
[TR]
[TD]02/01/2012</SPAN>[/TD]
[TD="align: right"]0.85</SPAN>[/TD]
[TD="align: right"]0.83</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>[/TABLE]
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