If your lookup value appears multiple times, use SUMIF to
sum for each occurrence:

=VLOOKUP(A1,Sheet2!A:D,4,0)

becomes

=SUMIF(Sheet2!A:A,A1,Sheet2!D:D)

HTH
Jason
Atlanta, GA

-----Original Message-----
using vlookup i can select a value from a different
worksheet, but can i
select a range of values to sum together?
.