How To Put Vlookup In Excel 2013

The vlookup function in excel performs a case insensitive lookup.

How to put vlookup in excel 2013. You can use the lookup function to return the price in cell h2 when you enter the auto part number in cell h1. You can put the email addresses next to the names and phone numbers by using. Microsoft excel 2013 boasts a huge number of handy functions and utilities. For example lets say you know the part number for an auto part but you dont know the price.

For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. This also applies for excel 2010 and 2007. What is vlookup used for. In this example we want to find the price of mangoes.

There are more articles on vlookup and hlookup. Vlookup function is used to search and retrieves data from a specific column in the table. Lookupvalue can be a value or a reference to a cell. How to use vlookup in excel.

The value you want to look up. Vlookup is one of the most useful formulas in excel. You can perform these function in excel 2016 2013 and 2010. Published on mar 21 2013 easy and simple way to learn vlookup vertical lookup in excel 2013.

Vlookupgift basket a2b16 2 false it would be very tedious to edit your vlookup formula whenever you want to find the price of a different item. Vlookup cannot look to the left of the column that its searching. The value you want to look up must be in the first column of the range of cells you specify in the tablearray argument. If we want to find the price of a different item we can just change the first argument.

Hope you understood how to use the vlookup function in excel. For example if table array spans cells b2d7 then your lookupvalue must be in column b. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. Many people shy away from vlookup initially but once you learn how to use vlookup function in excel 2013 youll be able to make the most of this powerful feature.

Open a document with a table.