How To Use Vlookup

So lets see if we can get that clear first.

How to use vlookup. Otherwise vlookup will not retrieve the correct data. The cell range also needs to include the return value you want to find. Select cell e4 and enter the vlookup function shown below.

To use wildcards with vlookup you must specify exact match mode by providing false or 0 for the last argument rangelookup. When using the vlookup function in excel you can have multiple lookup tables. The first column in the cell range must contain the lookupvalue.

Create two named ranges. In this final example were using vlookup to locate the discount percentage that should be used for various bulk orders of shoes. You can use the if function to check whether a condition is met and return one lookup table if true and another lookup table if false.

For instance you can use vlookup to retrieve values from a table after typing in only part of a lookup value. The vlookup function supports wildcards which makes it possible to perform a partial match on a lookup value. You can use a named range or a table and you can use names in the argument instead of cell references.

In the example above you would insert the vlookup function into another spreadsheet with an item code and it would. If you need vlookup help or if you have additional questions on how to use vlookup please let me know by posting a comment. The range of cells in which the vlookup will search for the lookupvalue and the return value.

Vlookup only works with data thats organized in columns eg in vertical sections meaning that your data most likely has headers in the top row of cells but not in the far left column of cells. The hardest part of using vlookup is understanding exactly what its for. If your data is organized by rows instead youll wont be able to use vlookup to find a value.