Help putting cells in different categories
 

Hey,
I have a list of 15 different sources and I need to put them into 5
different categories. I know that I could great a gigantic OR array in my
formula, but I was curious if there was an easier way.
So I have category Customer that includes Request, email and inquiry
Category Company that includes News, Internet, Sales, Phone and Magazine
That is an example of 2 of the 5 categories...any help would be appreciated.
Thanks

Help putting cells in different categories
 

Make up a list of sources down a column:

Request
email
inquiry
News
Internet
Sales
Phone
Magazine
etc.

Then next to that list, categorize them:

Request Customer
email Customer
inquiry Customer
News Company
Internet Company
Sales Company
Phone Company
Magazine Company
etc. Whatever

And use Vlookup to extract the category, like

=VLOOKUP(A2,Table,2,False)

where table is the address of the list that you just created, say H2:I16, like so:

=VLOOKUP(A2,$H$2:$I$16,2,False)

HTH,
Bernie
MS Excel MVP


"phd4212" wrote in message
...
Hey,
I have a list of 15 different sources and I need to put them into 5
different categories. I know that I could great a gigantic OR array in my
formula, but I was curious if there was an easier way.
So I have category Customer that includes Request, email and inquiry
Category Company that includes News, Internet, Sales, Phone and Magazine
That is an example of 2 of the 5 categories...any help would be appreciated.
Thanks