Re: Pulling Data

Giganews Newsgroups
Subject: Re: Pulling Data
Posted by:  Peo Sjoblom (terre…@mvp.org)
Date: Thu, 16 Oct 2003

One way

=INDEX(B2:B10,MATCH(SMALL(A2:A10,COUNTIF(A2:A10,"<"&C2)+1),A2:A10,0))

where A2:A10 is the dates, B2:B10 the data you want returned and C1 the
input date

--

Regards,

Peo Sjoblom

"matt" <matthew_elliott…@yahoo.com> wrote in message
news:003e01c393f9$87844c00$a30128…@phx.gbl...
>  A        B          C
> 5/15/03  105    10/16/03
> 5/15/04  103
> 5/15/05  101
> 5/15/06  100
>
> How can I have cell D1 pull the number 103? If the date in
> C1 is after a date in column A, pull the next date? Thanks

Replies

None

In response to

Pulling Data posted by matt on Thu, 16 Oct 2003