ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need a formula (https://www.excelbanter.com/excel-discussion-misc-queries/71992-i-need-formula.html)

Doug

I need a formula
 
I need a formula. What I am trying to do is, I Have a column with acct. no.
going down from 1-30 on the next column I have what the accts. are in the
next is a dollar figure. On a differnt page I have it looking like a check
book regester with a column for the account I want to put it in. I need a
formula that will see what account I entered and put the total in that
account number on the next page.
Can any one can help

paul

I need a formula
 
vlookup your account name from the second sheet on the first sheet and pull
the ammount from the third row

--
paul
remove nospam for email addy!



"Doug" wrote:

I need a formula. What I am trying to do is, I Have a column with acct. no.
going down from 1-30 on the next column I have what the accts. are in the
next is a dollar figure. On a differnt page I have it looking like a check
book regester with a column for the account I want to put it in. I need a
formula that will see what account I entered and put the total in that
account number on the next page.
Can any one can help



All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com