You can either use an IF statement, provided you do not have a lot of
categories, or you could set up a list of descriptions and their related
categories, and then use a VLOOKUP statement. Something like
=IF(C2="","",VLOOKUP(C2,CatList,2,FALSE)). In the example, your list of
descriptions and categories would be named CatList

--
Hth

Kassie Kasselman
Change xxx to hotmail


"la90292" wrote:

I have a worksheet for my YTD business expenses. Column C is Description.
Column E is Category. If for example, Union 76 is in the Description
column, I want to the corresponding cell in the E column to be, "Auto: Fuel"
so all the descriiptions of Union 76 will be categorized, Auto: Fuel.

Thank you in advance for your time and consideration.

Best regards,
SeaTiger