Maybe you can use this technique of dependent lists:
http://contextures.com/xlDataVal02.html

Hope this helps,
Miguel.

"scott" wrote:

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