what formula to use

[lovella]

my sample worksheet below, i need to find out max reading per month say for jan (sheet2)max is 20.1924,
that value i got has a corresponding fluctuation in sheet 3, the answer i should get is 0.9746 , what formula can i adopt to achieve this. thanks heaps

sheet2
[TABLE="width: 232"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]1/01/2013[/TD]
[TD][/TD]
[TD="align: right"]19.9707[/TD]
[TD][/TD]
[TD="align: right"]19.6133[/TD]
[/TR]
[TR]
[TD="align: right"]2/01/2013[/TD]
[TD][/TD]
[TD="align: right"]20.1924[/TD]
[TD][/TD]
[TD="align: right"]20.1312[/TD]
[/TR]
[TR]
[TD="align: right"]3/01/2013[/TD]
[TD][/TD]
[TD="align: right"]15.4229[/TD]
[TD][/TD]
[TD="align: right"]15.2118[/TD]
[/TR]
[TR]
[TD="align: right"]4/01/2013[/TD]
[TD][/TD]
[TD="align: right"]10.2059[/TD]
[TD][/TD]
[TD="align: right"]11.1228[/TD]
[/TR]
[TR]
[TD="align: right"]5/01/2013[/TD]
[TD][/TD]
[TD="align: right"]11.814[/TD]
[TD][/TD]
[TD="align: right"]10.8905[/TD]
[/TR]
</tbody>[/TABLE]

sheet3

[TABLE="width: 230"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]1-Jan-13[/TD]
[TD="align: right"]0.9754[/TD]
[TD="align: right"]0.9779[/TD]
[/TR]
[TR]
[TD="align: right"]2-Jan-13[/TD]
[TD="align: right"]0.9746[/TD]
[TD="align: right"]0.9756[/TD]
[/TR]
[TR]
[TD="align: right"]3-Jan-13[/TD]
[TD="align: right"]0.9622[/TD]
[TD="align: right"]0.9637[/TD]
[/TR]
[TR]
[TD="align: right"]4-Jan-13[/TD]
[TD="align: right"]0.9622[/TD]
[TD="align: right"]0.971[/TD]
[/TR]
[TR]
[TD="align: right"]5-Jan-13[/TD]
[TD="align: right"]0.965[/TD]
[TD="align: right"]0.9586[/TD]
[/TR]
</tbody>[/TABLE]

 

[VoG]

Please continue here http://www.mrexcel.com/forum/excel-questions/789608-what-function-use-find-data-matrix.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).