T
Tom Culp
Is there an equivalent @ function in Excel that works like the @CHOOSE Quattro Pro function? I have tried LOOKUP and VLOOKUP and they do not seem to fit my needs because they cannot handle a blank.
I am converting a numerical value in a cell to a word using the following:
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")
Where the numeric contents of cell K2 are either: blank, 1, 2, 3, 4 or 5. A 5 in K2 returns Island. A blank in K2 returns a blank.
Thanks!
Tom
I am converting a numerical value in a cell to a word using the following:
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")
Where the numeric contents of cell K2 are either: blank, 1, 2, 3, 4 or 5. A 5 in K2 returns Island. A blank in K2 returns a blank.
Thanks!
Tom