In the selected cell use a function to lookup the total pledged associated with the donor type
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 … Read more