How To Use Vlookup In Excel 2016

How to employ VLOOKUP in Excel

How to use VLOOKUP in Excel

VLOOKUP is the go-to tool for finding information in large or complicated spreadsheets. Substantially it's a search function and forth with HLOOKUP, tin seek out values across the entire canvas. It is an amazingly useful tool that anyone who spends any fourth dimension in Excel needs to know. Here'southward how to employ VLOOKUP in Excel 2016.

VLOOKUP is more than merely using Ctrl + F in other Role documents. It is a total vertical (hence the 'V') lookup tool that can search the first column of a sail for anything independent within it. Forth with HLOOKUP (the Horizontal lookup tool), they allow you to search quickly and efficiently.

VLOOKUP in Excel 2016

To make VLOOKUP piece of work in Excel 2016 you need three pieces of information, the value yous're searching for, the data to search and the results cavalcade to place those results. They are expressed as lookup_value, table_array, col_index_num and range_lookup or:

VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

lookup_value is what yous're looking for.
table_array is the cell range to search.
col_index_num is data to search for.
range_lookup is whether you want an exact or judge match.

How to employ VLOOKUP in Excel

So now you know what VLOOKUP is, how do you employ it? Let us build your formula up stride by stride making it like shooting fish in a barrel to understand.

You may observe '$' betwixt characters within the formula, these tell Excel the terms are accented and to not mess with them. Information technology makes life a lot easier fifty-fifty if information technology does brand the formula harder to read.

The formula nosotros are going to terminate upwards with is '=VLOOKUP($F$2,$A$two:$C$55,3,False)'

Hither's how to build it.

Open your spreadsheet and find somewhere to place the results. Put a box effectually it or otherwise mark information technology out so you tin can run across clearly what is returned. (Cell F3 in our example).
Add a box above information technology in which to put your search criteria. (Cell F2 in the example).
Blazon '=VLOOKUP(' into F3 where you would like your data displayed.
Add where yous want the information displayed. For example, if you lot're sending the result to F2, your lookup should expect like: '=VLOOKUP($F$ii'.
Add together the search surface area of the spreadsheet. In the example, that'southward cells A2 to C55. '=VLOOKUP($F$2,$A$2:$C$55'.
Tell Excel what value you lot're looking for. In the example, that is salary and so we apply column 3. '=VLOOKUP($F$2,$A$2:$C$55,3'.
Tell the spreadsheet whether you need an exact match or approximate by calculation Truthful or Fake. Nosotros want an verbal match so: '=VLOOKUP($F$2,$A$2:$C$55,3,Imitation'.
Striking Enter.
Type a search criteria into the box at F2 you created in stride 2 and see the return in the box below at F3.

There yous have it, the anatomy of VLOOKUP in Excel 2016. Information technology is a powerful tool that makes life much easier when dealing with larger spreadsheets.

Thank you to Spreadsheeto.com for the sample.