Hi,

First want to say thanks to those who help me with previous questions.. that
helps me a lot.... Thank You!!!!

Here are another problem I am having difficult to solve... yup.. I am super
newbie...

Okay here are my problem...


B23-- can have either "on" or "off"


S1, S2, S3, S4, S5, S6 --- these cels can have either "yes" or "no"


In cel A10:

-----If B23 have "on" then check (Except S4)
--------------S1 and if yes then show "apple"
--------------S2 and if yes then show "boat"
--------------S3 and if yes then show "cup"
--------------S5 and if yes then show "pen"
--------------S6 and if yes then show "snoopy"
-------------- nothing is yes then show "neither"

-----If B23 have "off" then check (Except S6)
--------------S1 and if yes then show "apple"
--------------S2 and if yes then show "boat"
--------------S3 and if yes then show "cup"
--------------S4 and if yes then show "chuck"
--------------S5 and if yes then show "pen"
-------------- nothing is yes then show "neither"


Any Idea....

Thank you Everyone....!!!