How to populate a column in excel?

[GN0001]

I have a column of type of foods in column A, and I have 60,0000 rows, I need to label each food and put its category in column B, If I have Orange in column A, I need to enter Fruit in column B and so on, I have 10 Category Types for these 60,000 rows. I thought If I filter column A, and then populate column B, that may work. I wonder if there is another way of doing this.

Thank you for the response.

Guity

 

[vijaySharma]

Guity,


If you have the categories created, you need a simple VLOOKUP to complete this.


~VijaySharma

 

[GN0001]

Can you please explain it a little bit more? Thank you very much.

 

[NARAYANK991]

Hi ,


Can you give more details of :


1. What are your 10 categories ?


2. What are the different items you will enter in column A ?


Narayan

 

[S]

if your 10 categories are in column C and D

Your 10 categories here


ColumnC ...ColumnD

Orange.....Fruit

Fish...... SeaFood

Burger.... JunkFood

------ ------

------ ------


And your List in Column A and your Result will be in Column B if yoou input the vlookup formula in cell B2 and drag it down

=VLOOKUP(A2,$C$2:$D$4,2,0)

in above formual change the range $C$2:$D$4 to your 10 categories list range


ColumnA ... ColumnB

List: ...Result:

Orange ... Fruit

Orange ... Fruit

Fish ... SeaFood

Fish ... SeaFood

Burger ... JunkFood

Burger ... JunkFood

 

[GN0001]

Thank you for all. I did this in small sample, it worked. Thank you so very much for the help.

Guity