ExcelBanter - help I need a formula

Doug Wrote:
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 en
up if
entering it on the the 1st page J6-J36.
If anyone can Help, Please!!!

If you are entering dollar amount in J6-J36 where is the account # o
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 will be

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

You could autofill this formula to H6 - H35

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=51308