As you can see The expected output I want and what I have actually got
when I use index I get value and When I use match I don’t satisfy the condition.
I want to return the position of Rachana Aggarwal in the table using index and match such as position 7 in this case
I have shown the formula I have used in the Excel screenshot for Position column in the query
>Solution :
Do not use index + match. Use only MATCH and substract rows of headers: =MATCH(B21, B1:B11,0) - 1