Less cumbersome multiple lookup

[drluke]

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

[TABLE="class: grid, width: 500, align: right"]
<tbody>[TR]
[TD]COL A[/TD]
[TD]COL B[/TD]
[/TR]
[TR]
[TD]Formula = Bottle or Night[/TD]
[TD]Could be any of Water or Day[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[becci.gott]

Is this what you have at the moment?
=IF(B1="Water","Bottle",IF(B1="Day","Night"))

Would it be better to use a VLOOKUP?

 

[Joe4]

You can also use a LOOKUP function:

=LOOKUP(B1,{[COLOR=#ff0000]"Day","Water"[/COLOR];"Night","Bottle"})

Add you can keep adding to that (you said that you have four possible values).
Just note that the values in red (the values you are matching on) must be in alphabetical order.
For more on the LOOKUP function, see: https://www.techonthenet.com/excel/formulas/lookup.php