hi!
I am preparing a basic calculator for myself for some funds and I got into a
trouble...
there is a excel file U can download...
http://www.andergrant.com/problem.zip

so..
"a, b, c, d, e, f" sheets are the names of funds
the problem is in the sheet called 'main' in the cell F109. I want this cell
to feedback me the number taken from sheet 'a' from the row number 4 BUT
!!! - I WANT IT TO FEEDBACK IT FROM TODAY!!! (I want to query to
compare/check today's date and answer with a proper number under the today's
date).
So the feedback for such a query for today (2004-11-27) should be 5049,92.
If today's would be 2004-11-22 the feedback for sheet 'a' would be 5050,11 -
I hope U are enable to see it...

Please give me a hand with it - I would be very thankfull

thx.up front
m.

Try

=HLOOKUP(A1,a!2:4,3)

Note you want the 3rd Row in the A!2:4 Range

Ian Huitson



"| m o []" wrote:

hi!
I am preparing a basic calculator for myself for some funds and I got into a
trouble...
there is a excel file U can download...
http://www.andergrant.com/problem.zip

so..
"a, b, c, d, e, f" sheets are the names of funds
the problem is in the sheet called 'main' in the cell F109. I want this cell
to feedback me the number taken from sheet 'a' from the row number 4 BUT
!!! - I WANT IT TO FEEDBACK IT FROM TODAY!!! (I want to query to
compare/check today's date and answer with a proper number under the today's
date).
So the feedback for such a query for today (2004-11-27) should be 5049,92.
If today's would be 2004-11-22 the feedback for sheet 'a' would be 5050,11 -
I hope U are enable to see it...

Please give me a hand with it - I would be very thankfull

thx.up front
m.