Download the featured files here: https://www.bluepecantraining.com/wp-content/uploads/2023/03/VLOOKUP-REF-Error.zip

In this Microsoft Excel video tutorial I explain three possibilities for why you are getting the REF error whilst performing a VLOOKUP.

Table of Contents:

00:00 - Introduction
00:17 - Col index is greater than the number of columns in your table array
00:52 - Table array doesn't include the correct number of columns
01:28 - Your table array is another workbook and housed an Excel Table
------------------------