excel - query please help!!!!!!

[| m o []]

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.

 

[chadt74]

From what I can tell is just looks like you are looking for a simple
HLOOKUP on these (maybe I'm missing something).

In F109 I put the following : =HLOOKUP($A$1,a!A2:IT4,3,FALSE) and it
seemed to work for me. The only problem is on days like today (30th)
you will get a NA back as you do not have that date in the list of
dates so excel does not find that data point. The formulas going down
from F019 are as follows:

=HLOOKUP(A1,b!A2:HD4,3,FALSE)
=HLOOKUP(A1,'c'!A2:CE4,3,FALSE)
=HLOOKUP(A1,d!A2U4,3,FALSE)
=HLOOKUP(A1,f!A2:EP4,3,FALSE)

Hope this helps and if you have any other questions or want a slightly
revised SS just email me and I can shoot it to you.