Formula for Inputing a Value based on a Condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

la90292 - 09 Sep 2007 20:51 GMT

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

Reply to this Message

kassie - 09 Sep 2007 21:24 GMT

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

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> 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
[quoted text clipped - 5 lines]
> Best regards,
> SeaTiger

Reply to this Message

la90292 - 09 Sep 2007 22:54 GMT

Hi Kassie:

Thank you for your suggestion. I'm a little lost as to how to set up the
CatLst as your recommend. Do I create a new Column, CatLst and input, using
my example, Union 76 Auto: Fuel?

Thanks,
SeaTiger

> 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
[quoted text clipped - 13 lines]
>> Best regards,
>> SeaTiger

Reply to this Message

kassie - 10 Sep 2007 05:12 GMT

Not knowing the setup of your sheet, maybe on sheet 2, type in a list of your
descriptions, say in Col A. Then in Col B, enter the category for each
description, next to the latter. Say in A1 you have Union 76, then in B1
enter Auto : Fuel, in A2 enter say Appleton Parkade, then in B2 Auto :
Parking, and so on. Sort this list alphabetically on Col A. Iow, Select
A1:Bwhatever, click on Data, Sort, Col A. Now click on Insert, Name, Define,
and type in CatList, or whatever you prefer to call this list.

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Hi Kassie:
>
[quoted text clipped - 22 lines]
> >> Best regards,
> >> SeaTiger

Reply to this Message