On another worksheet, create two lists, one with chips, and another with
all three items.
Name each list, e.g. ChipsList and PayList
There are naming instructions he
http://www.contextures.com/xlNames01.html

In the data validation cell, choose DataValidation
For Allow, select List
For the Source, enter the formula:
=IF($A$1="MB",PayList,ChipsList)


Teddy-B wrote:
Hi everyone. I need a validation formula that will allow (only) the word
"CHIPS" in the validation cell if cell A1<"MB". If Cell A1="MB", then the
words "CASH, CHIPS, or CHECK" (only) may be entered.

Please help- "Thanks"


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html