Excel 2016 – 3.8.5 – Nest 2 MATCH Functions Into INDEX

We’re now going to select a full table to work with. This means that we have to nest two MATCH functions into the INDEX function. This is a real ‘Left Lookup’.