Excel's VLOOKUP function

VLOOKUP fetches information from another table based on a lookup value. With it, you can, for example, match product codes with prices from different lists.

You will need

• Excel
• Two tables that share a common identifier

Steps

1. Understand the structure

   VLOOKUP: =VLOOKUP(lookup_value, table, column_number, FALSE). In Finnish-language Excel it is called PHAKU, and semicolons are used as separators.

2. Make sure there is a common identifier

3. Write the formula

4. Use exact match

5. Lock the table range

6. Handle errors

7. Try XLOOKUP

The full guide with every step is for members. Try 7 days for €0.99.

People also search for: excel vlookup · how do i use vlookup in excel · why does my vlookup return n/a · look up a value from another sheet · vlookup in the finnish version of excel phaku

More guides on: Digital skills and AI

• Spotting phishing
• Backing up your computer
• Choosing a cloud service
• Setting up a printer
• Connecting Bluetooth devices
• Sharing your screen
• Taking a screenshot on any device
• Updating your apps

Digital skills and AI – All guides ›