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