Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Hi:
The dataset for the vllokup contains many rows with the same reference: Ex Coupon # Transaction Sales 1 5 $ 10 2 7 $3 1 3 $15 When I write =vlookup(A3,"SheetName" $A;$E, 2,0) I only get one number for each unique coupon # instead of a sum of all coupon numbers. Can you help? Thanks. Heather |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Hi Heather
what exactly do you want as output? 1 8 $25 then you would do following (assuming that you're first row is a header) =SUMIF(Sheet1!$A$2:$A$4,$A8,Sheet1!$B$2:$B$4) which you can then drag to the right side, and then drag down. hth Carlo On Jan 16, 1:47*pm, Learningfast wrote: Hi: The dataset for the vllokup contains many rows with the same reference: *Ex Coupon * # * * * * * * Transaction * * * * * * * * *Sales 1 * * * * * * * * * * * * *5 * * * * * * * * * * * * * * * *$ 10 2 * * * * * * * * * * * * *7 * * * * * * * * * * * * * * * * *$3 1 * * * * * * * * * * * * *3 * * * * * * * * * * * * * * * * * $15 When I write =vlookup(A3,"SheetName" $A;$E, 2,0) I only get one number for each unique coupon # instead of a sum of all coupon numbers. Can you help? Thanks. Heather |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |