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.