K
Ksean
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 I’ll 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
spreadsheets ‘Financial’, ‘Registrants’ and ‘Start’
The answer/formula is to be in cell J3 on sheet ‘Financial’ so I’ll 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