Forum Discussion

DPRC512's avatar
DPRC512
Copper Contributor
May 11, 2022
Solved

IF statement based on dropdown list help

I have a dropdown list of product names and want to create an IF formula in another column to populate the experimental product number associated with the product name. So select the product from the list, the neighboring cell then populates the experimental number. 

I keep getting an error and I'm not sure why.

Example:

=IF(B2="productX",ABC-123, IF(B2="productY",DEF-456))

 

Can you not create an IF statement from a cell with a dropdown list?

Resources