Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
which function to choose? | Excel Worksheet Functions | |||
Which function to choose? | Excel Worksheet Functions | |||
Choose Function | Excel Discussion (Misc queries) | |||
CHOOSE function | Excel Discussion (Misc queries) | |||
CHOOSE Function | Excel Worksheet Functions |