FIND Function

FIND works the same way as LOOKUPVALUE, with the exception that the lookup value does not have to have an exact match. If the match is exact then that row is returned, otherwise, the first row that is greater than the lookup value is used:

FIND(index_of_column_ to_lookup, value_to_lookup, index_of_column_to_return, BQL_query)