Feb 03 2020 07:22 AM - edited Feb 03 2020 09:58 AM
Working on creating a formula for example:
My D5 Cell Can contain Values: 36B,37F,38B,42A Where 36B=S, 37F=M, 38B=H, 42A=M.
How can I set this for and IF function, to have the E5 column populate based of of what is imputed in D5?
Right now trying: =IF(D5="36B","S"),(D5="37F","M''),(D5="38B","H"),(D5="42A","M") with no success.
This is working for the 36B=S, and 37F=M. I cannot get to work with 38B=H and 42A=M
=IF(D3="36B","S",IF(D3="37F","M"))
Feb 03 2020 12:02 PM - edited Feb 03 2020 12:03 PM
Rather than a many-layered IF formula, you might find it easier--and longer term more flexible--to use the VLOOKUP function. I've done it in the attached example. This would enable you to readily change the answers, even add more possibilities by extending the table in the upper left-hand corner.
I didn't do it here, but you can also use Data Validation to restrict the range of entries allowed in cell D5 to the possible entries you've expected or required.