Surely Vlookup will do what you want. That's what it was designed for. Set up a
table with the code in one column and the name in the next.

If you are still having trouble, post back with the vlookup formula and what the
table looks like.

--
Regards,
Fred


"scats" wrote in message
...
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