Excel 2016 – 3.8.4 – Combine INDEX and MATCH

In this video we will nest the MATCH function into the INDEX function. This is a basic Left Lookup as the selection for each function will be a single column.