17.1 C
London
Saturday, July 26, 2025
HomeSoftware TutorialsExcelHow to Perform a VLOOKUP with Two Lookup Values

How to Perform a VLOOKUP with Two Lookup Values

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the following basic formula to perform a VLOOKUP with two lookup values in Excel:

=VLOOKUP(F1&F2,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,FALSE)

This particular formula looks up the values in F1 and F2 in the ranges A2:A10 and B2:B10, respectively, and returns the corresponding value in the range C2:C10.

The following example shows how to use this formula in practice.

Example: Perform VLOOKUP with Two Lookup Values

Suppose we have the following dataset in Excel that shows the points scored by various basketball players:

Now suppose we would like to use a VLOOKUP function to find the points value that corresponds to a Team value of Mavs and a Position value of Center.

To do so, we can type the following formula into cell F3:

=VLOOKUP(F1&F2,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,FALSE)

The following screenshot shows how to use this formula in practice:

VLOOKUP with two lookup values in Excel

The formula returns a value of 31.

This is the correct points value that corresponds to the player on the Mavs team who has a position of Center.

Note that we can change the values in column F to find the points value for a different player.

For example, if we change the Team to Spurs and the Position to Guard, the VLOOKUP function will automatically update to find the points value for this player:

The formula returns the correct points value of 40.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Calculate a Weighted Percentage in Excel
How to Multiply Column by a Percentage in Excel
How to Calculate Percentile Rank in Excel

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories