How can 0 be used in the Choose function
=CHOOSE(A2+1,"Salary","Medical Aid","Benefits","Car Allowance","Mobile
Allowance")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Max" wrote in message
...
Hello,
We download data from a software package that uses numbers 0,1,2,3,4 to
indicate a catagory.
0 - Salary
1- Medical Aid
2 - Benefits
3 - Car Allowance
4 - Mobile Allowance
This information is downloaded into Excel into a table.
Want to convert the the 0, 1, 2, etc into the relevant string (Salary or
Medical Aid etc), the function Choose does not allow 0 to be as an index.
Is there a alternative formula, or is there a way to get the Choose
function
to read the 0?
Thank you and best regards
Max
|