"scats" wrote:



"scats" wrote:

my budget workbook is setup where you have an input page and then living exp,
trans, medical, checking sheets, etc. the input page is setup per month, you
enter the amount and the code (wp=water payment, ep= electric payment, etc).
what i'm need to know is on the checkbook sheet, how do I make it recognize
the name for the code in the range. i've tried VLOOKUP & SUBSTITUE. i can get
substitue to work for only 2 codes at a time. the formula i'm using is
=substitue(substitue(range,"code","name"),"code"," name"). I need it to
recognize 5 codes in the range.the codes are TP=Bellsouth, GP=Amerigas,
WP=Water company, BD= bank deposit, and BWD=bank withdrawl debit. please help
me to figure this out. it's driving me crazy lol. thanks

my workbook is setup with 7 sheets (input, income, living exp, trans, etc.).
i enter the data on the input sheet which is linked to all sheets but the
checkbook sheet. the input page looks like this:

B C E F H I
T U
jan feb mar
company code
amount code amount code amount code
water bill wb
$111 wb $100 tb $100 gb
phone bill tb
$111 wp $100 tp $100 gp
gas co. gb

b=bill p=payment

i use the bank for certain bills. what i need is a formula for the checkbook
page so when i pay a bill or make a deposit it logs in the checkbook. the
checkbook page is a template resembling a regular checkbook log. i've worked
with excel alot but have not worked with functions like vlookup. thanks for
helping.

B C E F T U
jan Feb Company Code
Amount code amount code phone tp
100 tb 50 wb water wp
100 tp 50 wp