16.4 C
London
Wednesday, June 18, 2025
HomeSoftware TutorialsExcelExcel: How to Use IF and VLOOKUP Nested Function

Excel: How to Use IF and VLOOKUP Nested Function

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 use an IF and VLOOKUP nested function in Excel:

=IF(VLOOKUP(D2,$A$1:$B$11,2,FALSE)>100,"Yes","No")

This particular formula looks up the value in cell D2 in the range A1:A11 and finds the corresponding value in B1:B11.

If this value is greater than 100, “Yes” is returned.

Otherwise, “No” is returned.

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

Example: How to Use IF and VLOOKUP Nested Function

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

We can type the following formula into cell E2 to determine whether or not the Mavs scored more than 100 points:

=IF(VLOOKUP(D2,$A$1:$B$11,2,FALSE)>100,"Yes","No")

Once we press Enter, the results will be shown:

From the results we can see that the Mavs did score more than 100 points.

Note that if we change the team name in cell D2, the results will automatically update.

For example, suppose we change the team name to Suns:

From the results we can see that the Suns did not score more than 100 points.

Additional Resources

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

Excel: How to Perform a VLOOKUP with Two Lookup Values
Excel: How to Use VLOOKUP to Return Multiple Columns
Excel: How to Use VLOOKUP to Return All Matches

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