Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup - effect of adding columns | Excel Discussion (Misc queries) | |||
Adding to VLOOKUP table | Excel Discussion (Misc queries) | |||
Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |