I don't know if the question must be put here or on SO. Sorry if i make a mistake.
I have to search the first and last occurrence of a certain value within a column(array). I have managed to make use of Index and Match functions to return the first value at left of the searched column (right vlookup), but now i'm having trouble to invert the search order of the lookup (to instead of finding the first occurrence, find the last occurrence).
V = -2
freq DB
557 -1
558 -2
559 -2
559 -1
INDEX(A3:A6;(MATCH(A1;B3:B6;0))) is my "rigth vlookup"
freq
sorted? You could use an array formula for that, but it'll be easier if it is sorted.