Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can 0 be used in the Choose function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can 0 be used in the Choose function
Well done and thank you Bob.
It was so simple. "Bob Phillips" wrote: =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can 0 be used in the Choose function
Hi,
Here are some other alternatives: If you set up a table in Excel which looks like: 0 Salary 1 Medical Aid 2 Benefits 3 Car Allowance 4 Mobile Allowance say in the range G1:H5 then you could use any of these formulas among many others: =VLOOKUP(A1,G1:H5,2) =VLOOKUP(A1,{0,"Salary";1,"Medical Aid";2,"Benefits";3,"Car Allowance";4,"Mobile Allowance"},2) =LOOKUP(A1,G1:G5,H1:H5) =LOOKUP(A1,G1:G5,{"Salary";"Medical Aid";"Benefits";"Car Allowance";"Mobile Allowance"}) or shortest of all =LOOKUP(A1,G1:H5) -- Cheers, Shane Devenshire "Max" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |