How to use VLOOKUP Function in Excel
What is the VLOOKUP function?
The VLOOKUP function is a built-in function in Excel, classified as a Lookup/Reference Function. It can be used as a workbook function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a worksheet cell.
The VLOOKUP function is actually quite easy to use once you understand how it works!
For example: If you know the name of a product and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. However, for novice Excel users, setting up VLOOKUP may look like an intimidating process – but it doesn't need to be. Just follow our step-by-step guide on how to use VLOOKUP in Excel today.
How to use VLOOKUP in Excel
Step 1 . Click the cell where you want to calculate the VLOOKUP formula.
How to use VLOOKUP Function in Excel Picture 1
Step 2 . Click ' Formula ' at the top of the screen .
How to use VLOOKUP Function in Excel Picture 2
Step 3 .Click ' Lookup & Reference ' on the Ribbon.
How to use VLOOKUP Function in Excel Picture 3
Step 4.Click ' VLOOKUP ' at the bottom of the drop-down menu.
How to use VLOOKUP Function in Excel Picture 4
Step 5.Specify the cell where you will enter the value whose data you are looking for. In this case, our lookup value is H2, as this is where we would enter the name of a tournament, such as 'PGA Championship', so we enter 'H2' in the store's Lookup_value box popup. Once we have VLOOKUP set up properly, Excel will return the Total Rating Value in cell H3 when we enter the tournament name in cell H2.
How to use VLOOKUP Function in Excel Picture 5
Step 6. Specify the data that you want VLOOKUP to use for its search in the Table_array box . In this case, we've selected the entire table (not including the headers).
How to use VLOOKUP Function in Excel Picture 6
Step 7 . Specify whether you need an exact match by entering FALSE (exact match) or TRUE (approximate match) in the Range_lookup box . In this case we want an exact search we enter FALSE .
How to use VLOOKUP Function in Excel Picture 7
Step 8 . Click ' OK ' at the bottom of the pop-up window.
How to use VLOOKUP Function in Excel Picture 8
Step 9 . Enter the value for which data you are looking for. In our example, we want to find the Total Value Rating of the PGA Championship, so we enter 'PGA Championship' in cell H2 and VLOOKUP automatically generates the Total Value Rating (914 in this case) in cell H3 .
How to use VLOOKUP Function in Excel Picture 9
Using VLOOKUP , you not only search for individual values but also combine two spreadsheets into one. For example, if you have a spreadsheet with names and phone numbers and another sheet with names and email addresses, you can put the email address next to the name and phone number by using VLOOKUP
You should read it
- VLOOKUP function to use and specific examples
- Vlookup function in Excel
- How to combine Vlookup function with If function in Excel
- How to automate Vlookup with Excel VBA
- Use VLOOKUP to join two Excel tables together
- How to use the IF function with VLOOKUP (examples and how to)
- VLOOKUP function - Usage and detailed examples
- How to use Vlookup function between 2 sheets, 2 different Excel files
- How to combine Sumif and Vlookup functions in Excel
- How to use the XLOOKUP function in Excel?
- How to filter duplicate data on 2 Excel sheets
- How to fix VLOOKUP error in Excel
May be interested
How to create arrow symbols, write arrow marks in Word, Excel
5 Ways to find and replace words and phrases in Word 2019
Tips for quickly calculating Totals in Excel
Merge cells in Excel
Summary of 50 Excel shortcuts you should know by 2023
8 How to delete blank rows in ExcelHow to delete blank rows in Excel