Adding using Vlookup
 

I wanted to use a vlookup formula to locate values using "data" as my
reference point and add them. There are several cells that reference "data,"
however, when I run my formula, can only pick one of the values up and not
add all the other values using "data."

=+IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
Summary'!$C$18:$N$262,7,0),""))

This is the generic formula that locates one of the "data" values, but not
the sum of all the values using "data" as a reference point.

Adding using Vlookup
 

Actually, the formula entered will give you a #value. The generic formula I
used was +VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0)

"Moy Emrick" wrote:

I wanted to use a vlookup formula to locate values using "data" as my
reference point and add them. There are several cells that reference "data,"
however, when I run my formula, can only pick one of the values up and not
add all the other values using "data."

=+IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
Summary'!$C$18:$N$262,7,0),""))

This is the generic formula that locates one of the "data" values, but not
the sum of all the values using "data" as a reference point.

Adding using Vlookup
 

I am not sure how your data looks but have you considered using sumif formula.

=sumif(range,value)

Nikki

"Moy Emrick" wrote:

Actually, the formula entered will give you a #value. The generic formula I
used was +VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0)

"Moy Emrick" wrote:

I wanted to use a vlookup formula to locate values using "data" as my
reference point and add them. There are several cells that reference "data,"
however, when I run my formula, can only pick one of the values up and not
add all the other values using "data."

=+IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
Summary'!$C$18:$N$262,7,0),""))

This is the generic formula that locates one of the "data" values, but not
the sum of all the values using "data" as a reference point.

Adding using Vlookup
 

Oh, nikki you're so fine you're so fin you blow my mind, hey Nikki!

Yeah, I just figured it out a few minutes ago. Thanks for the followup though!

moy

"Nikki" wrote:

I am not sure how your data looks but have you considered using sumif formula.

=sumif(range,value)

Nikki

"Moy Emrick" wrote:

Actually, the formula entered will give you a #value. The generic formula I
used was +VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0)

"Moy Emrick" wrote:

I wanted to use a vlookup formula to locate values using "data" as my
reference point and add them. There are several cells that reference "data,"
however, when I run my formula, can only pick one of the values up and not
add all the other values using "data."

=+IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
Summary'!$C$18:$N$262,7,0),""))

This is the generic formula that locates one of the "data" values, but not
the sum of all the values using "data" as a reference point.