How to use VLOOKUP with an Excel Table

Tip: How to use VLOOKUP with an Excel Table

In this video, we’ll look at how to use VLOOKUP to lookup values in an Excel Table.

On this worksheet, I have a table that contains employee data, named Table1.

To illustrate how to work with VLOOKUP when the source data is in a table, I’ll set up formulas to the right to extract data from the table, matching on an employee ID.

First, I’ll select the table header and use paste special with transpose to get the field values.

Then I’ll add some formatting, and an ID value so I have something to match against.


Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *