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

Hi Mel,

I'm not quite clear:

On Jan 29, 2:25*pm, wrote:
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).

Please show the lookup formula.
Which cells hold the class data?
Which cells hold the rate data?

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.

How do you check off 'wrong class'?
What is the location of the 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.

K9 displays which cell?
Where do you want the classes to diplay?
How do you know the correct class?

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

Mel