Assign A Word To Specific Set Of Text

[ExcelRaceRatings]

Hi there,

Hoping someone can help with the below issue:

I have a set of words in A1:A5

A1 - Apple
A2 - Bacon
A3 - Banana
A4 - Water
A5 - Museli Bar

I want to be able to assign specific words to the above text. For example in B1:B5 i'd like to automate to say:

B1 - Fruit
B2 - Meat
B3 - Fruit
B4 - Drink
B5 - Snack

Hoping someone may be able to assist?

Thanks in advance!

 

[Eric W]

You need to create a cross-reference table with the relationships you want. For example:

Excel 2010

	A	B	C	D	E
1	Apple	Fruit		Apple	Fruit
2	Bacon	Meat		Banana	Fruit
3	Banana	Fruit		Cherry	Fruit
4	Water	Drink		Orange	Fruit
5	Muesli Bar	Snack		Bacon	Meat
6				Hamburger	Meat
7				Turkey	Meat
8				Water	Drink
9				Milk	Drink
10				Gatorade	Drink
11				Peanuts	Snack
12				Muesli Bar	Snack
13				Twinkee	Snack
14

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

End​

Worksheet Formulas Cell Formula B1 =VLOOKUP(A1,$D$1:$E$13,2,FALSE) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Hope this helps!