Excel 2016 – 3.8.1 – Why Do You Need a Left LOOKUP?

This video gives you an explanation and example as to why a VLOOKUP will not work with our data, and why we need to carry out a ‘Left Lookup’. There is no function called ‘Left Lookup’ – we simply work with 2 different functions, INDEX and MATCH, to create the impression of a Left Lookup.