#1   Report Post  
| m o []
 
Posts: n/a
Default excel - query

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.


  #2   Report Post  
Ian Huitson
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 05:08 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 07:03 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 08:54 PM
Excel Query Via Sybase Gary Excel Discussion (Misc queries) 1 December 7th 04 08:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"