What does it do?
Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
What it means:
=VLOOKUP(this value, TableName, and get me value in this column, Exact Match/FALSE/0])
Excel Tables are just amazing and should be used all the time, whether you have 2 rows or 200,000 rows of data!
You can read the benefits of using an Excel Table here:
When you use a Vlookup formula to lookup in an Excel Table then your formula becomes dynamic due to its structured referencing.
What that means is that as the Excel Table expands with more data added to it, your Vlookup formula’s 2nd argument (table_array) does not need to be updated as it refers to the Excel Table as a whole by referring to its name eg Table1 or Table2 or Table3 etc
In the example below our Excel Table name is Table2 and as we add more rows of data to it, the Vlookup formula does not need to be adjusted. How bloody cool is that?