Excel: in the selected cell use a function to lookup the total pledged associated with the donor type using the lookup table?
Assuming you already have a total next to a donor type, use:
=VLOOKUP(A1, Y1:Z50, 2, FALSE)
Where:
A1 is the donor type
Y1:Y50 is a list of donor types
Z1:Z50 is the amount pledged for each donor type.
In the selected cell use a function to lookup the total pledged associated with the donor type