Replace 25+ Nested IFs with a Single Lookup Function

preview_player
Показать описание

This short video shows how to replace nested IF functions with a single lookup function.
Specifically:
- Drop down with 25+ categories
- The selected category determines fee percentage
- Fee percentage is applied to price
- Approach: nested IF functions
- Approach: IFS function
- Approach: SWITCH
- Approach: lookup table
- Approach: XLOOKUP

Chapters in this video:
00:00 - Introduction
00:21 - Exercise 1
03:38 - click-start
03:42 - Exercise 2
04:22 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

  1. Excel University
  2. excel
  3. microsoft excel
  4. excel tips and tricks
  5. chatgpt
  6. chat gpt
Рекомендации по теме
Replace 25+ Nested 0:05:49

Replace 25+ Nested IFs with a Single Lookup Function

Excel - Replaced 0:04:57

Excel - Replaced Nested IF with VLOOKUP - Episode 2030

Quickly Replace Nested 0:05:07

Quickly Replace Nested IFs with VLOOKUP - Supper Trick

Rule #25- Avoid 0:03:30

Rule #25- Avoid nested if/else blocks

Excel IF Formula: 0:15:23

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

Create a Custom 0:07:48

Create a Custom Excel Function to Replace Nested IF Functions

Replace nested IFs 0:02:45

Replace nested IFs with VLOOKUP- Amazing Idea #shorts #short

IF Function Excel 0:09:03

IF Function Excel With Multiple Conditions | Nested IF, IFS Function | IF with 2 or More Conditions

HOW TO CHANGE 0:02:06

HOW TO CHANGE YOUR MYPLAYERS NAME IN NBA 2K25 | NEXT GEN

[Free Excel Tutorial] 0:10:33

[Free Excel Tutorial] CREATE A CUSTOM FUNCTION TO REPLACE NESTED IF FUNCTION - FULL HD

Alternatives to Nested 0:11:56

Alternatives to Nested IF Formulas || IFS || SWITCH || CHOOSE Functions

Excel Tutorial - 0:05:51

Excel Tutorial - Multiple conditions within an IF function

How to Use 0:06:42

How to Use IF Function with 3 Conditions in Excel | Step by Step | Practical Example

IF Function with 0:07:17

IF Function with 4 Criteria in Excel | IF Formula with many Conditions

Master the IF 0:11:16

Master the IF Formula in Excel (Beginner to Pro)

VLOOKUP to Replace 0:03:30

VLOOKUP to Replace Nested IF Formula

IFS formula in 0:08:36

IFS formula in Excel (Replacement of Nested IF; RIP IF 😔) || Part-02, Advance discussion

Excel IFS Function 0:05:14

Excel IFS Function is a Nice Alternative to Nested IF Functions

17 ENG VBA 0:08:17

17 ENG VBA Excel Nested IFs for multilevel decisions

10 Advanced IF 0:21:55

10 Advanced IF formulas every analyst should know

Excel SWITCH Function 0:08:09

Excel SWITCH Function - Nested IF's Just Got Easier

REPLACE MULTIPLE IF 0:06:39

REPLACE MULTIPLE IF STATEMENTS WITH A SINGLE VLOOKUP

How to use 0:03:57

How to use the IFS function in Excel

IFS formula in 0:11:15

IFS formula in Excel (Replacement of Nested IF; RIP IF 😔) || Part-01, Basic discussion with example...

Комментарии
Автор

I like it when formulas are shorter and less complicated. thanks Paul

PaulEBrownbill
Автор

Super! How excel is easy with you! Thumbs up 👍

khalil
Автор

Nice work Jeff. Even easier to write the formula when you name the ranges. CategoryRng and RateRng and the Price cell as PriceVal. turns into: =XLOOKUP(D2, CategoryRng, RateRng)*PriceVal

markperrah