find the next cell that houses a date

[Tonyson]

in workbook sheet1 cells A1 to G1 houses dates for each column. on sheet2 (same workbook) F3 I want to type any of the dates from sheet1 A1:G1, I need a formula in in cell G3 that will give me the date in the following cell that matches F1.
Say if sheet1 B1= MAY-2004 and C1= JUL-2004 and I type May-2004 on sheet2 F3 the formula on G3 will give me JUL=2004.

 

[PaddyD]

Book2
	A	B	C	D	E	F	G
1	Jan-01	Feb-01	Mar-01	Apr-01	May-01	Jun-01	Jul-01
2
3
4	Find	Feb-01
5	Return	Mar-01
Sheet1

formula is:

=INDEX(A1:G1,,MATCH(B4,A1:G1)+1)

 

[Tonyson]

Thanks, that was what I was looking for, but I didn't put the double ,, before Match. I learn something new everyday.
ray:

 

[Yogi Anand]

Thanks, that was what I was looking for, but I didn't put the double ,, before Match. I learn something new everyday.
ray:

Hi Tonyson:

No, it is not the ,, that would have caused you the problem -- it must have been something else. since Paddy's formulation will also work with a single comma instead of two commas, as illustrated in ...

Book3
	A	B	C	D	E	F	G
1	01-Jan	01-Feb	01-Mar	01-Apr	01-May	01-Jun	01-Jul
2
3
4	Find	01-Feb
5	Return	01-Mar
Sheet6

 

[Tonyson]

Thanks Yogi ! I'll keep that in mind you guys are great.