IF + VLOOKUP (conditional lookup) Function in Excel: Syntax, Examples and Free Practice
IF + VLOOKUP (conditional lookup) is an Excel Logical function. Picks which of two different lookup tables to search, based on a condition.
IF + VLOOKUP (conditional lookup) syntax
Arguments
condition: Which table to usekey1/table1: Lookup for the TRUE casekey2/table2: Lookup for the FALSE case
When to use IF + VLOOKUP (conditional lookup)
Pulling a price from a Wholesale table or a Retail table depending on customer type.
Practice IF + VLOOKUP (conditional lookup) online, free
Open the live Excel-style spreadsheet and try IF + VLOOKUP (conditional lookup) yourself. No Excel install or sign-up needed to start.
Practice IF + VLOOKUP (conditional lookup) now →More Logical functions
- IF + AND
- Nested IF
- Nested IF (3 levels)
- IF + AND + OR (combined)
- IFS + AND
- IF + ISERROR
- IF + ISBLANK
- IF + OR
- IF + ISNUMBER
- IF + TODAY
- Nested IF + VLOOKUP (tiered lookup)
- IF + LEN (input validation)
- VLOOKUP + ISERROR (existence check)
Frequently asked questions
What does the IF + VLOOKUP (conditional lookup) function do in Excel?
Picks which of two different lookup tables to search, based on a condition.
What is the syntax of IF + VLOOKUP (conditional lookup) in Excel?
The syntax is =IF(condition, VLOOKUP(key1, table1, 2, FALSE), VLOOKUP(key2, table2, 2, FALSE)). condition: Which table to use; key1/table1: Lookup for the TRUE case; key2/table2: Lookup for the FALSE case.
Where can I practice IF + VLOOKUP (conditional lookup) online for free?
Open the free live spreadsheet on Cellgrids and try IF + VLOOKUP (conditional lookup) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logical functions · Excel case studies · Excel tutorials · Excel shortcuts