IF command for multiple text options

[kiwi44]

Hi everyone,

I am trying to set up a formula for the following type of scenario:

Column A ---> Column B:
Apple ---> Fruit
Kale ---> Vegetable
Banana ---> Fruit
Carrot ---> Vegetable
Kale ---> Vegetable

What formula can I put in Column B in order to make sure that all Apples and Bananas (from column A) are listed as Fruit, and all Kale and Carrots are listed as Vegetables

Thanks in advance for the help!

 

[NeonRedSharpie]

Either use a VLookup into another sheet (recommended) or a long nested IF(OR()) statement.

 

[kiwi44]

Either use a VLookup into another sheet (recommended) or a long nested IF(OR()) statement.

Thanks! I'm not too skilled with excel, so I looked up VLookup. That seems to be for if Column B is already filled out. I'm trying to find an easy way to fill Column B with "Fruit" and "Vegetable" designations based on Column A.

Would the IF(OR()) statement work in this case?

 

[Jonmo1]

You need to build a lookup table that tells excel which values are fruits and which are vegetables.

Something like this, lookup table in E1:F4

Unknown
	A	B	C	D	E	F
1	Apple	Fruit			Apple	Fruit
2	Kale	Vegetable			Kale	Vegetable
3	Banana	Fruit			Banana	Fruit
4	Carrot	Vegetable			Carrot	Vegetable
5	Kale	Vegetable
Sheet1

Cell Formulas
Range	Formula
B1	=VLOOKUP(A1,$E$1:$F$4,2,0)
B2	=VLOOKUP(A2,$E$1:$F$4,2,0)
B3	=VLOOKUP(A3,$E$1:$F$4,2,0)
B4	=VLOOKUP(A4,$E$1:$F$4,2,0)
B5	=VLOOKUP(A5,$E$1:$F$4,2,0)