Hi,

1. Create the following table in some blank area of your spreadsheet:

no apple apple
no boat boat
no cup cup
Yes chuck
no pen pen
no snoopy
Yes neither neither

2. In my example the range was D1:F7.
3. In cell D1 enter =S1
4. Copy this formula down to D6. Leave Yes in D7.

In A10 enter the following formula:

=VLOOKUP("yes",D1:F7,IF(B23="on",2,3),FALSE)

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Astroboy" wrote:

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....!!!