vlookup sum()?
 

Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!

vlookup sum()?
 

I found it - you basically need to add vlookupM01 +VlookupM02 etc:)

"Claudia" wrote:

Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!

vlookup sum()?
 

try:
=SUMPRODCUT((A:A="xxxx")*B:D)


--
Regards,

Sebation.G
"Claudia" ...
Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!

vlookup sum()?
 

Hi Claudia

Provided you enter your XXXX as a Text value, e.g. '2007
then
=SUMPRODUCT((LEFT(B$1:N$1,4)=A2)*(RIGHT(B$1:N$1,2) ="01")*
(RIGHT(B$1:N$1,2)<="03")*$B2:$N2)

--
Regards

Roger Govier


"Claudia" wrote in message
...
Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined
quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!

vlookup sum()?
 

Thank you everyone!

"Roger Govier" wrote:

Hi Claudia

Provided you enter your XXXX as a Text value, e.g. '2007
then
=SUMPRODUCT((LEFT(B$1:N$1,4)=A2)*(RIGHT(B$1:N$1,2) ="01")*
(RIGHT(B$1:N$1,2)<="03")*$B2:$N2)

--
Regards

Roger Govier


"Claudia" wrote in message
...
Hello,

Could anyone help?

I have a data such as:

2007M01 2007M02 2007M03

XXXX 4 8 7

And I would like to vlookup the value for XXXX, but as a combined
quater
data: meaning sum(MO1,M02,M03).
Could someone, help me?

Thank you in advance!