Discussion Locked

MONTHLY ledger in Excel NEED HELP

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear Sir, I created a MONTHLY ledger in Excel with Column 30 AND 31 rows.

#1 Column "E" has a labeled "code".
In this row E1-31 I want to type "AT" for water bill "MCI", "ELE" for telephone etc.

#2 Since I don't know what row 1-31 these are going to fall at any given time I want
to type this codes "AT,MCI,ELE,
SW-BILL,FWM,HOME,CAR,CAP-ONE"
and have column "G" having the amount of the bill.

#3 Then I want column "G" is labeled "amount" having the (20.00) amount of the bill.

#4 Then I want column "M" labeled "At" show (20.00) amount for water bill.

#5 Column "N" will have "MCI" for telephone
and so on.

My question is can you give me the formula so when I type in "AT" the price
or amount It know to put the price inColumn "M" which is "AT" and also anywhere down that row.

There was a man who showed me this can be done but he has passed away and I
have lose the knowledge.

I can send you an attachment.

PS: It is a yearly page so I need to know how to pass this to the next ledger page. Maybe tied to the date.

FRANK
FFONTAN1@oncorgroup.com and ffbb@earthlink.ne

4 replies

by dklippert

Try something like this. Use the formula =VLOOKUP(Value to look up, Table, Column, False) The last element "False" assures that you make an exact match.

by ffontan1

I also have a problem when I type over a code and put a term in.
such as name or numbers it wipes out code. how do I stop that or how to fix it..
frank

This discussion is closed to new replies.