I have a spreadsheet that has a lookup formula to select a class that
if it is wrong and you check off the preceeding cell, the formula
looks up the alternative class. (some classes have the same rate so
you could have 1 rate with 4 different classes).

this works good if only 2 classes but I have some with up to 4
classes. So, if the original lookup provides class 1 and it is
wrong, I then check off 'wrong class' and the class field needs to be
able to give me the choice of 3 classes from a table.

Cell J9 is the question 'is class wrong' and cell k9 is the field that
displays the cell. This is the field that I would like to, if the
original lookup is wrong, change to the correct class. Having 1 other
class is easy but if I have 3 to choose from, How would I be able to
choose class 2,3, or 4 and have it diplay these classes and then after
choosing the correct class, it populates cell K9.

I think there is a way but have not been able to come up with what
would work best.
thx

Mel