I have a value, Say 22.135.
I have two Columns, A & B. "A" has sl.no in it. "B" has random values in an unsorted fashion.
I want to search for this value 22.135 and return it's corresponding sl.no.
If that value doesn't exist, I have to return the sl.no of a value immediately lesser than 22.135.
Say, a lesser value than 22.135 be, 22.132 and it occurs multiple times in various places in column B, then I have to return the sl.no of it's first occurence.
Urgent, need it for my project.
Bookmarks