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

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

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

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

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

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