In this tutorial what I am looking at is the alternative to Vlookup() – Index/Match which is – astonishingly enough – a combination of two functions: Index and Match. I give an explanation of Match in this tutorial as well. You can download the completed file here.