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

1/01/2013		19.9707		19.6133
2/01/2013		20.1924		20.1312
3/01/2013		15.4229		15.2118
4/01/2013		10.2059		11.1228
5/01/2013		11.814		10.8905

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

sheet3

1-Jan-13	0.9754	0.9779
2-Jan-13	0.9746	0.9756
3-Jan-13	0.9622	0.9637
4-Jan-13	0.9622	0.971
5-Jan-13	0.965	0.9586

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

 

[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).