software

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

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

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

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)

quot;Moy Emrickquot; wrote:

gt; I wanted to use a vlookup formula to locate values using quot;dataquot; as my
gt; reference point and add them. There are several cells that reference quot;data,quot;
gt; however, when I run my formula, can only pick one of the values up and not
gt; add all the other values using quot;data.quot;
gt;
gt; = IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
gt; Summary'!$C$18:$N$262,7,0),quot;quot;))
gt;
gt; This is the generic formula that locates one of the quot;dataquot; values, but not
gt; the sum of all the values using quot;dataquot; as a reference point.

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

=sumif(range,value)

Nikki

quot;Moy Emrickquot; wrote:

gt; Actually, the formula entered will give you a #value. The generic formula I
gt; used was VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0)
gt;
gt; quot;Moy Emrickquot; wrote:
gt;
gt; gt; I wanted to use a vlookup formula to locate values using quot;dataquot; as my
gt; gt; reference point and add them. There are several cells that reference quot;data,quot;
gt; gt; however, when I run my formula, can only pick one of the values up and not
gt; gt; add all the other values using quot;data.quot;
gt; gt;
gt; gt; = IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
gt; gt; Summary'!$C$18:$N$262,7,0),quot;quot;))
gt; gt;
gt; gt; This is the generic formula that locates one of the quot;dataquot; values, but not
gt; gt; the sum of all the values using quot;dataquot; as a reference point.

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

quot;Nikkiquot; wrote:

gt; I am not sure how your data looks but have you considered using sumif formula.
gt;
gt; =sumif(range,value)
gt;
gt; Nikki
gt;
gt; quot;Moy Emrickquot; wrote:
gt;
gt; gt; Actually, the formula entered will give you a #value. The generic formula I
gt; gt; used was VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0)
gt; gt;
gt; gt; quot;Moy Emrickquot; wrote:
gt; gt;
gt; gt; gt; I wanted to use a vlookup formula to locate values using quot;dataquot; as my
gt; gt; gt; reference point and add them. There are several cells that reference quot;data,quot;
gt; gt; gt; however, when I run my formula, can only pick one of the values up and not
gt; gt; gt; add all the other values using quot;data.quot;
gt; gt; gt;
gt; gt; gt; = IF(VLOOKUP(E18,'DD1921 Summary'!$C$18:$N$262,7,0),SUM(VLOOKUP(E18,'DD1921
gt; gt; gt; Summary'!$C$18:$N$262,7,0),quot;quot;))
gt; gt; gt;
gt; gt; gt; This is the generic formula that locates one of the quot;dataquot; values, but not
gt; gt; gt; the sum of all the values using quot;dataquot; as a reference point.