[Free Excel Tutorial] HOW TO USE THE VLOOKUP FUNCTION IN EXCEL - Full HD
[Free Excel Tutorial] HOW TO USE THE VLOOKUP FUNCTION IN EXCEL - Full HD
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book).
Before you start, you should understand the basics of functions. Check out our Functions lesson from our Excel Formulas tutorial (or select a specific version of Excel). VLOOKUP works the same in all versions of Excel, and it even works in other spreadsheet applications like Google Sheets. You can download the example if you'd like to work along with this article.
The fourth argument tells VLOOKUP whether to look for approximate matches, and it can be either TRUE or FALSE. If it is TRUE, it will look for approximate matches. Generally, this is only useful if the first column has numerical values that have been sorted. Because we're only looking for exact matches, the fourth argument should be FALSE. This is our last argument, so go ahead and close the parentheses:
A recent case involved some voter registration data I needed to analyze. On one Excel spreadsheet, the voter’s party was listed as an alphanumeric value called “Pcode” and not the political party. This coding wasn’t intuitive. For example, “D” was for “American Independent Party”, but some thought it meant “Democratic Party”.
VLOOKUP is a powerful Excel function that allows you to look for a specified value in one column of data inside a table, and then fetch a value from another column in the same row.
Free Excel Tutorial, HOW TO USE THE VLOOKUP FUNCTION IN EXCEL, Full HD
Free Tutorial, USE THE VLOOKUP FUNCTION IN EXCEL, Full, HD
Excel Tutorial, VLOOKUP FUNCTION IN EXCEL
This video [Free Excel Tutorial] HOW TO USE THE VLOOKUP FUNCTION IN EXCEL - Full HD is copyrighted for Rui Ludovino channel: • [Free Excel Tutorial] HOW TO USE THE VLOOK...