what function to use to find data in matrix

[lovella]

Hi to ol, need help please, on what function to use in my spreadsheet.
what am working on sheet 1 is finding the max value per month from the data in sheet 2. of which i have use formula =MAX(IF(TEXT(Sheet2!A:A,"MM")="01",Sheet2!D:AY)), thank God success on this.
my prob is the value i had from this formula has a matching value on sheet3, what formula to use in order to get say value x, any chance i can upload my data here?

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

 

[lovella]

my sample worksheet below, i need to find out max reading per month say for jan max is 20.1924, that value i got has a corresponding fluctuation in sheet 3, the answer i should get is 0.9746, what function formula can i adopt for this please .... <tbody> </tbody> 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>

<colgroup><col><col span="5"></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>

 

[vogel997]

1/1/2013	19.9707	19.6133			Try this..
2/1/2013	20.1924	20.1312
3/1/2013	15.4229	15.2118		20.1924	=LARGE(B1:C5,1)
4/1/2013	10.2059	11.1228
5/1/2013	11.814	10.8905		0.9746	=OFFSET(B9,IFERROR(MATCH(E3,B1:B5,0),MATCH(E3,C1:C5,0))-1,IF(IFERROR(MATCH(E3,B1:B5,0),0)=0,1,0))
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 width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;"> <col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;"> <col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;"> <col width="64" style="width: 48pt;"> <col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <col width="914" style="width: 686pt; mso-width-source: userset; mso-width-alt: 33426;"> <tbody> </tbody>

 

[lovella]

HI Thanks vogel997,very much appreciated, thought no ones going to pick up my query. I'll try the formula. Thanks in heaps!