In an ideal world I would do a 22 nested If statement to check but
unfortunately Excel 2000 will only allow 7.

What I have is a random subset of 5 values from 22 possibilities.


The "english" for the formula is like this:


If A2 = "Fri" then If B2 = Medic, a+b, if B2 = Home, b+c, so on and so
forth for 22 possible options.


I need to propogate this down a table so need the cell references in
the formulas to increment


Any help would be appreciated.


Thank you