Based on the data I have in col B, I am attempting to insert a code in col A. Any one of 4 different data items could be in col B.
Is there a formula that is less cumbersome than IF B=Water then A=Bottle or IF B=DAY then A=NIGHT etc... Any advise greatly appreciated!!
<tbody>
</tbody>
Is there a formula that is less cumbersome than IF B=Water then A=Bottle or IF B=DAY then A=NIGHT etc... Any advise greatly appreciated!!
COL A | COL B |
Formula = Bottle or Night | Could be any of Water or Day |
<tbody>
</tbody>