Rather than VLOOKUP, take a look at the SUMIF function.

=SUMIF(range_to_search,match,range_to_sum)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Valerie" wrote in message
...
I need to sum all of the values in a vlookup formula. Currently the
formula
only brings the value over for the first item that is found. It does not
continue to search the table for additional values and sum all of the
values
together.

Any help would be appreciated.
--
Valerie