Hi

Need to find the next value that is less than 'x', however it needs to ignore blanks, which is what its currently getting stuck on.

The current formula
=IFERROR(ROW(INDEX((INDIRECT("'"&$B216&"'!C"&ROW()+1&":C10000")),SUMPRODUCT(MATCH(1,--((INDIRECT("'"&$B216&"'!C"&ROW()+1&":C10000"))<D216),0)),1)),"NO SALE")

The problem is that it returns cells that have a blank(zero) in them. Is there a way to have it skip blank cells - the required value will never be zero.

Note the blank cell is a tab from a tab separated CSV file.

Cheers

Sam