Help with a formula

[Ross Horn]

I am a relatively new user of excel. I have a spreadsheet which I use to produce our companies monthly financial statements. The spreadsheet has two (2) columns on it: one column for the general ledger account number and the the other is the amount. A small example of what the spreadsheet looks like is

Col A Col
Account
Number Amoun

31100-103-0 -450.6
43100-220-0 1,275.6

I have the capability of importing the trial balance from our system which would include the general ledger account number and amout. What I am trying to figure out is a formula that would take the imported trial balance amount for an account and put it into my spreadsheet. It would save me great amount of time not to have to imput the data monthly.

Any solutions would be greatly appreciated. Thanks.

 

[Ozzie]

Using the data below, you could do a vlookup formula, as
long as the downloaded data is in numberic order (by
account number). Download the data to your spreadsheet, to
the tab labeled data. Then on your other table which is
the statements do the vlookup

=VLOOKUP(A2,data!A2:B200,2,FALSE)

for a two column table with 199 lines of date. Use the
function wizard (Fx symbol on the toolbar) to get you
through setting it up..

-----Original Message-----
I am a relatively new user of excel. I have a spreadsheet

which I use to produce our companies monthly financial
statements. The spreadsheet has two (2) columns on it: one
column for the general ledger account number and the the
other is the amount. A small example of what the
spreadsheet looks like is:

Col A Col B
Account
Number Amount

31100-103-0 -450.62
43100-220-0 1,275.63

I have the capability of importing the trial balance from

our system which would include the general ledger account
number and amout. What I am trying to figure out is a
formula that would take the imported trial balance amount
for an account and put it into my spreadsheet. It would
save me great amount of time not to have to imput the data
monthly.

 

[Ozzie]

In order to be of any additional help (assumng my first
response was helpful) I would need to see more of a
sample. I'm accountant by trade so I am familar with what
you are doing.

Also, I can't read any message that starts out with Re:

(e-mail address removed)

-----Original Message-----
I am a relatively new user of excel. I have a spreadsheet

which I use to produce our companies monthly financial
statements. The spreadsheet has two (2) columns on it: one
column for the general ledger account number and the the
other is the amount. A small example of what the
spreadsheet looks like is:

Col A Col B
Account
Number Amount

31100-103-0 -450.62
43100-220-0 1,275.63

I have the capability of importing the trial balance from

our system which would include the general ledger account
number and amout. What I am trying to figure out is a
formula that would take the imported trial balance amount
for an account and put it into my spreadsheet. It would
save me great amount of time not to have to imput the data
monthly.