Nested IF + VLOOKUP (tiered lookup) Function in Excel: Syntax, Examples and Free Practice
Nested IF + VLOOKUP (tiered lookup) is an Excel Logical function. Picks from three different pricing/lookup tables depending on a customer's tier.
Nested IF + VLOOKUP (tiered lookup) syntax
Arguments
tier: Which tier the customer is inid: Lookup key
When to use Nested IF + VLOOKUP (tiered lookup)
Pulling the correct price for a customer depending on whether they're Gold, Silver, or Standard tier.
Practice Nested IF + VLOOKUP (tiered lookup) online, free
Open the live Excel-style spreadsheet and try Nested IF + VLOOKUP (tiered lookup) yourself. No Excel install or sign-up needed to start.
Practice Nested IF + VLOOKUP (tiered 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
- IF + VLOOKUP (conditional lookup)
- IF + LEN (input validation)
- VLOOKUP + ISERROR (existence check)
Frequently asked questions
What does the Nested IF + VLOOKUP (tiered lookup) function do in Excel?
Picks from three different pricing/lookup tables depending on a customer's tier.
What is the syntax of Nested IF + VLOOKUP (tiered lookup) in Excel?
The syntax is =IF(tier="Gold", VLOOKUP(id, gold_table, 2, FALSE), IF(tier="Silver", VLOOKUP(id, silver_table, 2, FALSE), VLOOKUP(id, standard_table, 2, FALSE))). tier: Which tier the customer is in; id: Lookup key.
Where can I practice Nested IF + VLOOKUP (tiered lookup) online for free?
Open the free live spreadsheet on Cellgrids and try Nested IF + VLOOKUP (tiered 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