The VLOOKUP formula is one of the lookups that we all have to learn to use.
It is designed for Looking up a certain value in an array.
Human Translation: If we have a bunch of names in one column with their salary in the one next to it we can find a name and the corresponding salary with VLOOKUP.
Structure of the Excel VLOOKUP formula
=VLOOKUP(What to LOOKUP, Where to LOOKUP, How many columns to the right,What kind of Match)
So the VLOOKUP formula will ask us the four parameters above.
All the parameters are separated with a comma.
1. lookup_value – WHAT we want to Look up (This can be value, or text)
2. table_array – WHERE we want to look it up (This wants to be an array)
3. col_index_num – HOW MANY COLUMNS TO THE RIGHT is the information we want back
4. [range_lookup] – EXACT OR APPROXIMATE match we required
So basically for the formula we need to show:
-What we want to look up
-Where we want to look it up
-How many columns to the right is the thing we want to show
-And if we need exact or approximate match.
If you confident with the VLOOKUP formula perhaps you want to check out the Intermediate Excel formulas category.
People often misspell VLOOKUP as:
vlook up, vlooku, voookup, vloojup, vookup, vlookupp, vloookup, vlokup, vlooup, vlookkup, vllookup, flookup, clookup, vvlookup, vlokoup, vlookip, vloomup, vlokkup, vlookuo, vlookul, vlookyp, vlookpu, volokup, vlookp, vllokup, vlooukp or v look up, v lookup v look up, v lookup, or simply lookup…
But those guys who misspell VLOOKUP need to find our tutorial too so we keep these examples for them. 🙂
Did you know that we have a facebook page?
Check out ExcelAngel on facebook!