How to get specific "Text" value using IF condition with "Name Range"

[bala04msw]

Dear Forum,

I want to use the "Name Range" as logical test to return the specific "Text" Value.

For example:

Name range 1 - "Fruits" is the name range, which includes Apple, Orange, Papaya, Grapes, Banana.
Name range 2 - "Vegetable" is the name range, which includes Brinjal, Tomato, Potato, Onion.
Name range 3 - "Flower" is the name range, which includes Rose, Jasmin, Lotus, Sunflower

Requirement is, I want to have a return value in A1 as either "Fruit" or "Vegetable" or "Flower" based on the cell value in B1, which may have fruits or vegetable or flower name.

How can i get the result in A1. Kindly help me.

Thanks in advance

[JohnTopley]

Try

in B1

=IFERROR(IF(MATCH(A1,Fruits,0),"Fruits"),IFERROR(IF(MATCH(A1,Vegetable,0),"Vegetable"),IFERROR(IF(MATCH(A1,Flower,0),"Flower"),"")))

[bala04msw]

Dear Mr. John,

Thanks for your guidance, I will get back to soon with my testing observation and feed back.

Regards

[bala04msw]

Dear Mr. John,

Thanks for your formula, it works well.. I will add reputation soon, it shows, i can add reputation after spread reputation to some one else only. I will do it sure.