Date controlled formula

[Silver]

Hello I would like some help on a excel formula. I have a worksheet with
dates in one row and figures in other and want the totals to be shown @
another area.

Example

Date 01/02/2004 02/02/2004 03/02/2004 04/02/2004
05/02/2004

Amount 10 20 30
40 50




If I Input date here >>> 02/02/2004

Auto amount selected by formula in this cell = 20

& if I change the date to 03/02/2004 the amount would come up as 30



Any help would be appreciated.

Thank you

Z

 

[A.W.J. Ales]

Silver,

Have a look at the HLOOKUP function

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[RagDyer]

Are the dates and the numbers more or less contiguous, or at least do they
start and end in the same column?

Whether you use Lookup or Hlookup or Index and Match depends on the setup of
your list and whether or not you will require an *exact* match.

A little more info wouldn't hurt, so that you could receive an acceptable,
usable suggestion.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Hello I would like some help on a excel formula. I have a worksheet with
dates in one row and figures in other and want the totals to be shown @
another area.

Example

Date 01/02/2004 02/02/2004 03/02/2004 04/02/2004
05/02/2004

Amount 10 20 30
40 50




If I Input date here >>> 02/02/2004

Auto amount selected by formula in this cell = 20

& if I change the date to 03/02/2004 the amount would come up as 30



Any help would be appreciated.

Thank you

Z

 

[Frank Kabel]

Hi Silver
try something like
=HLOOKUP(A1,'sheet_with_dates'!$A$1:$G$2,2,0)
where A1 is your input date

Frank

 

[Silver]

Thank you all Hlookup works like a charm.

Hi Silver
try something like
=HLOOKUP(A1,'sheet_with_dates'!$A$1:$G$2,2,0)
where A1 is your input date

Frank