Can I get an IF() statement to return a list?

[LibbyK]

Hi,

I have an if statement that is pretty straight forward IF(productcell=productname,linearity,""). I have several nested if's with each productname returning one linearity value.

Unfortunately, for one productname, I have two linearity values I want returned in the form of a list that the user can then choose from linearity1 or linearity2. Is there any way to make and if statement call out a drop down list or return two values that the user can pick from?

I could do it using "smart lists" and Indirect(), but the users want the cell in question to populate without choosing from a list if there is only one choice. They only want a list to appear when there is an actual choice.

Libby