How to find a value and return the next value in Excel
May 6, 2021
You can use INDEX and MATCH function together to find a value and return the next value.
Now I want to find “AA” the next value of “Muny”
Select a cell that you want to place a return value
Then type =INDEX(C:C, MATCH(E3, B:B, 0))
Screenshot:
