function or command which can lookup the span length from the table which gives results as Pass

I want excel to search SPAN from the table of 'Span Length' on which it can pass MOMENT, hence I want to use a command that if it come fail the span automatically goes to next lowest available that c...