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>
COL A
COL B...