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...
=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!