If you always have 3 years worth of data, MATCH on the "c.code" and use
OFFSET function to get 2007-08 data.

"deepak bsg" wrote:

hello every body
i'm having a problem with formulas, i'm having
a data with sales volumes for different years and monthwise sales volumes i.e

c.code c.name apr may jun july tot
1010 xxxx 2005-06 10 25 10 25 70
2006-07 20 25 5 10 60
2007-08 30 25 55


1020 xxxx 2005-06 10 25 10 25 70
2006-07 20 25 5 10 60
2007-08 30 25 55

I want to copy the 2007-08 volumes by criteria c.code. I cannot copy the
c.code in to the all relative years(rows).Alredy i tried hlookup with if. But
i'm not
able to get it can any one assistance plz.

Thanks inadvance