INDEX & MATCH Formula examples/ tutorials

Hi All,

I`m a relatively basic excel user and am looking to build my own HR Dashboard. As part of this I`m discovering that INDEX and Match formulas are going to be a pretty crucial part of this. Does anyone know of or have any good examples/ tutorials that mights be helpful - i`ve seen some resources online but i must be honest that I`m struggling to get my head around this.

Thanks in advance.

Thanks NeedForExcel,

Really helpful videos with downloadable worksheets.

Much appreciated!