Here, we look for the price of an Apple MacBook Pro.
#HOW TO USE VLOOKUP IN EXCEL VIDEO TUTORIAL HOW TO#
How to Use VLOOKUP for Multiple Criteria? Let’s proceed to the next section and understand how to use VLOOKUP for multiple criteria. The value returned, in this case, is 8GB for the price of $1300.
![how to use vlookup in excel video tutorial how to use vlookup in excel video tutorial](https://i.ytimg.com/vi/h90tp9aTYEc/maxresdefault.jpg)
Finally, the last argument is set to TRUE. In the third argument, we give the column number, so that values for that column are returned.
![how to use vlookup in excel video tutorial how to use vlookup in excel video tutorial](https://i.ytimg.com/vi/tqwMuO8QP28/maxresdefault.jpg)
The second argument specifies the table range. The first argument will be the VLOOKUP value. Filter the price details in ascending order.After you click on the filter option, you will see the filter buttons enabled on your column headers. Next, select your data range and click on the filter option to sort the values of the first column based on ascending order. First, copy the price and RAM details to a new location, and specify your lookup value.If not, VLOOKUP will return incorrect values. We need to sort the first column in ascending order. So, let's use the Approximate Match to find the solution. Also, we know this value is not present in the table. In the example below, we use the VLOOKUP function to find out how much RAM specification a laptop priced 1300 EUR has. How To Find Approximate Match Using VLOOKUP?Īpproximate Match works by finding the next largest value that is lesser than the lookup value, which we specify. With the help of VLOOKUP in Excel, we can look for an approximate match as well. An N/A error is displayed in case the exact value is not found. Here, the value is set to FALSE for the VLOOKUP function to return an exact match for the value. The last argument is a Boolean Expression.This tells us what value should be returned from the row that we are looking up for. The third argument specifies the Column Index number.As you can see, the table location is A2:F11. We specify the location of the table in the second argument.So, we set the first parameter as the lookup value, which is the cell H5. In the example below, we are using the VLOOKUP function to find the value of the exact match of ID from the given table.Let’s take a look at how to do this with the help of an example: VLOOKUP makes it effortless to look for an exact match from the table. How To Find an Exact Match Using VLOOKUP? If the value is TRUE, then we are looking for an approximate match. range_lookup: This has two options if the value is set to FALSE, that means we are looking for an exact match.col_index_number: This specifies the column number from where we need to return the value.
![how to use vlookup in excel video tutorial how to use vlookup in excel video tutorial](https://i.ytimg.com/vi/7DzLzOHEi-E/maxresdefault.jpg)