practical business related question, IF, LOOKUP...?

[Guest]

Hi,I have a spreadsheet where I list my cash dispersements, I enter in the
payee and dollar amount information. What I want to do now is to be able to
enter a reference code for each payment (ex: Utilites, office expenses,
Repair etc...) and have the dollar amount (in column B) automatically copied
to a corresponding column further down, based on the reference code value I
enter in column C.

Example:
(A) (B) (C) (D)
(E) (F) (G)
Payee Amount Reference Utilites Supplies
Maintenace Misc
company a $100 utilites 100
company b $75 supplies 75
company c $60 maintenance
60


Also, Is there a way to use AutoSpell, or something similar, in Excel's
worksheets instead of typing every single company name out every time?

Any help would be greatly appreciated, thank you.
Ivan

 

[Debra Dalgleish]

You can use a data validation dropdown to select a company name. There
are instructions here:

http://www.contextures.com/xlDataVal01.html

You could use a pivot table or a SUMIF formula to total the amounts,
based on the items in column C. If you provide details about what you
want to do, someone may be able to offer specific help.