help I need a formula

[Doug]

I have 24 pages ( two pages per month)
1st page J6 - J36 I want to put a acct # in
next page F5 - F35 is a list of acct # with G5 - G35 showing what the
account is, the next H5 - H35 is where I want the dollar amount to end up if
entering it on the the 1st page J6-J36.
If anyone can Help, Please!!!

[avveerkar]

I have 24 pages ( two pages per month)
1st page J6 - J36 I want to put a acct # in
next page F5 - F35 is a list of acct # with G5 - G35 showing what the
account is, the next H5 - H35 is where I want the dollar amount to end up if
entering it on the the 1st page J6-J36.
If anyone can Help, Please!!!

If you enter dollar amount in J6-J36 where is the account # on first page? Let us assume that on first page ( sheet1) your account no. is in I6 - I36 and you enter corresponding dollar amounts in J6 - J36. And you want these amounts to get posted to H5-H35 of page 2 ( sheet2) against appropriate account # ( in F) and account description ( in G ). Then formula for H5 would be

= VLOKUP(F5,Sheet1!$I$6:$J$36,2)

You could autofill this formula to H6 - H35.

A V Veerkar