VLOOKUP Function Excel Tutorial - Find Things In A Table

This video explains how to easily find things in a table in Excel using the VLOOKUP function. Through examples, we will discuss the various components of the VLOOKUP function such as the lookup value, the table array or range containing the lookup value, the column number and whether we need to use an approximate or an exact match. We will also discuss the use of absolute references to ensure the table array within the VLOOKUP formula remains constant when dealing with a large number of cells.

Access the templates featured in The Excel Hub's video tutorials here:

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Example 1 Exact Match: (0:47)
Example 2 Approximate Match: (1:39)
Example 3 Additional Columns: (3:00)
Example 4 Absolute References: (4:35)

[aanchalagarwal]

Thank you so much for this video! Really helpful 🙂

[louislazarus]

how do I actually work out the calculation for tax rates