List in column B if Compagny in column A:

-Data/Validation/List
=IF($A2="Company",maliste,)

http://cjoint.com/?gdh6a785Kr

http://www.excelabo.net/compteclic.p...-listescascade

Cordialy JB

scott a écrit :

Hi,
Is it possible to have an IF statement result a drop down list?

Basically, I want to be able to have a dependent list if "COMPANY" is
selected in a previous drop down list. Otherwise, if any other option from my
list, such as "CUSTOMER" or "FACTORY" is selected, just return "N/A"?

Thanks,
Scott