Edit your formula and in the range box try typing false. This should return
what you are looking for.

"Richard" wrote:

The standard LOOKUP function (vector) requires that "The values in
lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ...,
A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase
and lowercase text are equivalent."

This is not convenient for me. The values I have in lookup_vector must
remain unsorted.

Is there a way to do this?