IF function

  • Thread starter Thread starter NOYB
  • Start date Start date
N

NOYB

I just can't figure out how to do this:

I need to reference a cell in the first row that meets a certain condition
(date greater than today's, but have this part figured). I only need to call
up the cell on the first qualifying row.

Any suggestions?

TIA
Bill S.
 
Hi
you may try the following array formula (entered with CTRL+SHIFT+ENTER)

=INDEX(A1:A1000,MATCH(TRUE,A1:A1000>TODAY(),0))
 
Back
Top