Help putting cells in different categories

P

phd4212

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
 
B

Bernie Deitrick

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
 
P

phd4212

I completely forgot about that. Thanks so much!

Bernie Deitrick said:
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
Click to expand...
 
Top