@CHOOSE Equivalent Function

[Tom Culp]

I have not been able to find an Excel @ function that works like the following Quattro Pro @ function. Is there an equivalent in Excel?

To change Facing Direction to Faces, where Facing Direction is col L
@CHOOSE($L2," ","N","S","E","W","B")

To change Side to Side, where Side is col K
@CHOOSE($K2," ","Right","Left","Ovhd","Median","Island")

In both of these formulas, the value in " " is returned to the active cell when the value in the cell is, in order, blank, 1, 2, 3, 4 or 5. A 5 in K2 returns Island.

I use these formulas to convert numerical data to words.

I have looked at LOOKUP AND VLOOKUP but they do not seem to function for my needs.

Thanks!
Tom

 

[Marcotte A]

Tr
=choose($K2," ", "Right",....etc.
(basically, change the '@' in your formula to an '='

 

[Tom Culp]

Thanks Marcotte! See reply to post several below this one. Also, Excel CHOOSE is 1 based while QPW is 0 based, so formula has to be modified to handle the situation I deal with.

Appreciate the reply!
Tom