Pulling Data

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

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
 
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
 
Back
Top