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