VLOOKUP - Row names not unique

[inquisitor]

When I query a datatable using VLOOKUP I get the answer returned fro
the first instance of a name that appears albeit in the correct column
If ABC is in row 2 with a value of 5 and also in row 3 with a value o
6, I get the reult 5 from row 2 in my formula. What I need is for
formula that will sum all instances of the row name ABC so giving m
the answer 11 (5+6). Ideally I don't want to go into VB scripting bu
can handle nesting ormulae. I don't want to use dat>subtotals either a
I need it to work 'behind the scenes'
I am using Excel 2000.
Any help would be gratefully received

 

[Don Guillett]

Have a look in HELP index for SUMIF

 

[Hans]

As far as I know, you can only "LOOKUP" one ABC and not
two and add them up.

However, you could make a pivottable of the the datatable
in another sheet (which will add the values of the two ABC
entries) and use your VLOOKUP on it.

regards,
Hans

 

[rbanks]

I'm not sure exactly what you're doing, but it sounds like you could us
a simple SUMIF formula.

=sumif(range,criteria,sumrange