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

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

i'm not able to get it.I tried this
=HLOOKUP(B3,HSD!B3:W1384,OFFSET(HSD!J3,3,1,1,1))

"Toppers" wrote:

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

Assuming original data is on sheet1 columns A to H, and extract in on Sheet2:

With A2=c.code, e.g 1010, then to get April data for 2007/08:

=INDEX(Sheet1!D2:D4,MATCH($A2,Sheet1!$A$2:$A$7,0)+ 2)

Copy across to get other months

Copy down for other c.code values e.g A3=1020

Change ranges as required

HTH

"deepak bsg" wrote:

i'm not able to get it.I tried this
=HLOOKUP(B3,HSD!B3:W1384,OFFSET(HSD!J3,3,1,1,1))

"Toppers" wrote:

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