Now, because VLOOKUP only looks to the right, it's important that the lookup is to the left of values we we want to retrieve. Now I'll write the first VLOOKUP formula.įor the lookup, I want the value from K4, locked so it doesn't change when I copy the formula down.įor table array, I want the lookup table itself, Table1. Then I'll add some formatting, and an ID value so I have something to match against. 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.įirst, I'll select the table header and use paste special with transpose to get the field values. On this worksheet, I have a table that contains employee data, named Table1. In this video, we'll look at how to use VLOOKUP to lookup values in an Excel Table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |