VLOOKUP is a great tool for pulling data from tables, but it has a handicap: it can only work with one criteria for matching information.If there are multiple rows in your sheet with the same information, you’ll only get the first one.
The vlookup function is one of the most useful tools in Excel, but also one that generates a lot of confusion.
It simply looks for data in a table that matches up to data somewhere else in your worksheet, and “copies” it over to somewhere else.
We’ll start with a very simple example and move on to more advanced concepts such as the hlookup function and using the match function with vlookup. First thing to is to “name” the range of the lookup table.
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade.
Excel Tactics is dedicated to helping you master it.
Join the newsletter to stay on top of the latest articles.Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!Normally, we would want to be able to enter the model of a car and get it’s fuel economy as a result.Unfortunately, Many cars, like the Acura ILX, have multiple engine configurations with different mileage ratings.Fortunately, in this case, the car’s displacement can serve to separate them.This means, however, that we will need to look up the car by both its Model and its Displacement at the same time to find the appropriate Combined Fuel Economy in column H.