Have you looked at SUMIF ?

Example:

=SUMIF(range_that_might_match,criteria,range_to_su m)

where range_that_might_match will be the first column of your table,
criteria is the lookup_value, and range_to_sum is the column you want
to sum where there is a match.

Hope this helps.

Pete

On Sep 21, 10:53*pm, dawgfan
wrote:
I have a huge spreadhset (and a deadline!) that VLOOKUP will find several
matches for the lookup_value. Each may have a diferent value at the
range_lookup. I need the formula to return a sum of all values. Please help
me figure out how to do it! Thanks very much!