Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Hi,
I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
If you only have those 3 conditions:
=IF(OR(A1={"Men","Women"}),"2700064 : More Categories",IF(A1="Hair","2700070 : More Categories","")) -- Biff Microsoft Excel MVP "Gmata" wrote in message ... Hi, I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
In B2: =INDEX({2700070,2700064,2700064}&" : More
Categories",MATCH(A1,{"Hair","Men","Women"},0)) "Gmata" wrote: Hi, I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
This will do the same thing:
=INDEX({2700070,2700064}&" : More Categories",MATCH(A1,{"Hair","Men"})) -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... In B2: =INDEX({2700070,2700064,2700064}&" : More Categories",MATCH(A1,{"Hair","Men","Women"},0)) "Gmata" wrote: Hi, I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Not really. If I put "What" in cell A1. "It returns 2700064 : More
Categories" instead of error or null string "T. Valko" wrote: This will do the same thing: =INDEX({2700070,2700064}&" : More Categories",MATCH(A1,{"Hair","Men"})) -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... In B2: =INDEX({2700070,2700064,2700064}&" : More Categories",MATCH(A1,{"Hair","Men","Women"},0)) "Gmata" wrote: Hi, I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Yeah, that's true but I was working on the assumption that "What" isn't a
possible entry. -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... Not really. If I put "What" in cell A1. "It returns 2700064 : More Categories" instead of error or null string "T. Valko" wrote: This will do the same thing: =INDEX({2700070,2700064}&" : More Categories",MATCH(A1,{"Hair","Men"})) -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... In B2: =INDEX({2700070,2700064,2700064}&" : More Categories",MATCH(A1,{"Hair","Men","Women"},0)) "Gmata" wrote: Hi, I need to create a formula to recall certain values for example if i type "Men" in A1 i need to get certain value in B2 "2700064 : More Categories" This are the 3 values i need Men --- 2700064 : More Categories Women --- 2700064 : More Categories Hair --- 2700070 : More Categories Any Help, Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|