You have a couple of options for this, depending on the way you set-up your
data.
Depending on the size of your file, you may be able to just use nested IF
statements to calculate the information for each person, which would possibly
calculate faster than a VLOOKUP. In general, a SUMIF command works much
faster, but that may not help you here. If you have a large data-set or you
are concerned with rate changes, then you would want to have a table set-up.
Before I get too deep into this, give me some more information on the size
and scope of your data. I would be happy to help.
