Excel 2016 – 3.7.5 – Combine VLOOKUP and Naming

If you find that you are regularly selecting the same table to look up – then you can save yourself some time by ‘Naming’ the table, so that you don’t have to physically select it.

Previous

Excel 2016 - 3.7.4 - Create a VLOOKUP That Doesn't Require an Exact Result
Next

Excel 2016 - 3.7.6 - Create a Drop-down Menu for the Lookup Value