General discussion

Locked

MONTHLY ledger in Excel NEED HELP

By ffontan1 ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

MONTHLY ledger in Excel NEED HELP

by DKlippert In reply to MONTHLY ledger in Excel N ...

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.

Collapse -

MONTHLY ledger in Excel NEED HELP

by ffontan1 In reply to MONTHLY ledger in Excel N ...

THANK you for the help.

Collapse -

MONTHLY ledger in Excel NEED HELP

by ffontan1 In reply to MONTHLY ledger in Excel N ...

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

Collapse -

MONTHLY ledger in Excel NEED HELP

by ffontan1 In reply to MONTHLY ledger in Excel N ...

This question was closed by the author

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums