Forum Discussion
DPRC512
May 11, 2022Copper Contributor
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 " " ?
- OliverScheurichGold Contributor
=IF(B2="productX","ABC-123",IF(B2="productY","DEF-456"))
Does it work if you enter the results with " " ?
- DPRC512Copper ContributorYes! Silly quotes. Thank you!