Forum Discussion
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?
=IF(B2="productX","ABC-123",IF(B2="productY","DEF-456"))Does it work if you enter the results with " " ?
=IF(B2="productX","ABC-123",IF(B2="productY","DEF-456"))Does it work if you enter the results with " " ?
- Yes! Silly quotes. Thank you!
