Can you show the sample of the data and how it should looks like?
--
Greatly appreciated
Eva


"Ksean" wrote:

With this problem I am dealing with a workbook that contains three
spreadsheets €˜Financial, €˜Registrants and €˜Start

The answer/formula is to be in cell J3 on sheet €˜Financial so Ill start
there now match the value in cell A3 on sheet €˜Financial to the value
somewhere in column B (B3:B800) on sheet €˜Registrants, once a match has been
found then go to column G on that row which has a date in it (i.e. May 8,
1996) and match only the year to the year somewhere in column B (B26:B47) of
sheet €˜Start, once a match has been found then go to column E on that row,
now display the contents of that cell back in cell J3 on sheet €˜Financial.

Thanks
Ksean