AFAIK the best place to start to learn the INDEX function is http://www.excelhero.com/blog/2011/0...ing-index.html

Very powerful and most users do not use it's full capability. The most important is to remember that INDEX returns a cell or range REFERENCE behind the screens.
This being said, my suggested solution is an array formula which might slow things down in case of large sheets

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post