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