which of the is the current we lookup formula option V lookup range V lookup value range V lookup value range result column exact match non of the above
Answers
When you want to pull information from a table, the Excel VLOOKUP function is a great solution. The ability to dynamically lookup and retrieve information from a table is a game-changer for many users, and you'll find VLOOKUP everywhere.
And yet, although VLOOKUP is a relatively easy to use, there is plenty that can go wrong. One reason is that VLOOKUP has a major design flaw — by default, it assumes you're OK with an approximate match. Which you probably aren't.
This can cause results that look completely normal, even though they are totally incorrect. Trust me, this is NOT something you want to try to explain to your boss, after she's already sent your spreadsheet to management :)
Read below learn how to manage this challenge, and discover other tips for mastering the Excel VLOOKUP function.
1. How VLOOKUP works
VLOOKUP is a function to lookup up and retrieve data in a table. The "V" in VLOOKUP stands for vertical, which means the data in the table must be arranged vertically, with data in rows. (For horizontally structured data, see HLOOKUP).
If you have a well structured table, with information arranged vertically, and a column on the left which you can use to match a row, you can probably use VLOOKUP.
VLOOKUP requires that the table be structured so that lookup values appear in the left-most column. The data you want to retrieve (result values) can appear in any column to the right. When you use VLOOKUP, imagine that every column in the table is numbered, starting from the left. To get a value from a particular column, simply supply the appropriate number as the "column index". In the example below, we want to look up the email address, so we are using the number 4 for column index:

In the above table, the employee IDs are in column 1 on the left and the email addresses are in column 4 to the right.
=VLOOKUP(value, data, column) =VLOOKUP(value, data, column, 1) =VLOOKUP(value, data, column, TRUE)