ferrarista
asked on
excel - using if function with multiple possibilities
Hi guys
I have a cell, say A1, where I can have various values. I need to place a value on say A2 depending on the value of A1.
I can have multiple values, say up to 4. How can I handle this without using VBA (not permitted) ?
Example:
A1 "red" then A2 "choice 1"
A1 "blue" then A2 "choice 2"
A1 "green" then A2 "choice 3"
A1 "white" then A2 "choice 4"
A1 "not a color" then A2 "not applicable"
How would I do that ? I could use either a function or some sort of conditional input (not sure this exists)...
Thanks all in advance.
I have a cell, say A1, where I can have various values. I need to place a value on say A2 depending on the value of A1.
I can have multiple values, say up to 4. How can I handle this without using VBA (not permitted) ?
Example:
A1 "red" then A2 "choice 1"
A1 "blue" then A2 "choice 2"
A1 "green" then A2 "choice 3"
A1 "white" then A2 "choice 4"
A1 "not a color" then A2 "not applicable"
How would I do that ? I could use either a function or some sort of conditional input (not sure this exists)...
Thanks all in advance.
ASKER
Sorry I mean a worksheet function, you know, an excel function, where you enter the equal sign and then the function you want to use, like a vlookup, a sum and so on......
Thanks.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it. Can I ask something more.
What if I want to combine the input of two cells ?
Example
A1 RED, A2 GREEN --> A3 RG
A1 BLUE, A2 GREEN --> A3 BG
How could I do that ?
Thanks so much for your help!
What if I want to combine the input of two cells ?
Example
A1 RED, A2 GREEN --> A3 RG
A1 BLUE, A2 GREEN --> A3 BG
How could I do that ?
Thanks so much for your help!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorrie Norie I don't get it. Where do you write the output ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Garfield and Dustin, and Norie.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks Rob
There you earn the points :< )
I can not copy & paste formulas from my XL.
This function i swedish is =LETARAD(A1;K10:Lxx;2;FALS KT) which can be translated as SEARCHROW(...
But by cowork I suppose ferrarista now got what he needs.
There you earn the points :< )
I can not copy & paste formulas from my XL.
This function i swedish is =LETARAD(A1;K10:Lxx;2;FALS
But by cowork I suppose ferrarista now got what he needs.
If it's the latter then it would mean using VBA.