Hi Bob, thanks for the formula, however, its not working the way i want it to.

what i want is for instance,if i select Guinness Ghana Breweries from cell b4, and also select 2008 as the start year from cell H4, and finally select 2 yrs from cell H6 ie the no. of yrs to view report, you will realise that cell b11 will have 2008, and what i expect in in cell b12 is 124848 (the revenue figure) and c11 will also read 2009 (since i selected 2yrs from cell h6) and the figure for that cell c12 will be 164441, thereafter everything shd be blank. in tht order. Hope you get what am trying to explain.

kindly help with a formula. tx again