IF function

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.
 
F

Frank Kabel

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Use TODAY() function as the criteria in a SUMIF formula 1
VBA word change keys 0
Cross-reference Insert Default Change 0
Merging from an Excel file with graphics 1
COUNTIF for 2 columns 7
Excel Logical function 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top