Excel 2016 - 3.8.7 - Left LOOKUP With Naming

The final step is to Name all the relevant parts – the table, the row headings and the lookup column – so that we don’t need to move off the sheet on which we are creating the Left LOOKUP.