Instead of using Nested IF, use LOOKUP and XLOOKUP

👉 how to use Nested Xlookup in excelПодробнее

Nested IF vs IF's & Foundation of Lookup, VLOOKUP and XLOOKUP for MasteryПодробнее

MS Excel - Nested IF | Alternate Way of Nested IF by Vlookup, Lookup | How to use Nested if functionПодробнее

Try The DGET Function Instead of INDEXMATCH & XLOOKUPПодробнее

STOP using nested IF statements! Use these functions instead.Подробнее

DO NOT Use Nested IF Functions in Excel - DO THIS InsteadПодробнее

VLOOKUP vs XLOOKUP - Detailed Comparison with ExamplesПодробнее

How to use XLOOKUP with Multiple Criteria in Excel - Lookup Formula with multi criteriaПодробнее

STOP Struggling with VLOOKUP Approximate Match! (XLOOKUP Included)Подробнее

VLOOKUP with Multiple Criteria in Excel: 2 Methods UnveiledПодробнее

Excel 101: Complex Analysis Using VLOOKUP, XLOOKUP,NESTED IF FUNCTIONSПодробнее

Nested IF Formula vs. VLOOKUP or XLOOKUP in Microsoft Excel #shortsПодробнее

Excel Tips - XLOOKUP and Nested XLOOKUP ExplainedПодробнее

How to Use XLOOKUP Function For 2 Different Lists In Excel (Nested XLOOKUP)Подробнее

XLOOKUP and Nested XLOOKUP (With 5 Practical Examples)Подробнее

XLOOKUP Sum of All Matches Using Excel | XLOOKUP or SUMIF? | XLOOKUP or SUMPRODUCT?Подробнее

XLOOKUP when there are multiple matches or occurrences (one simplified formula)Подробнее

IFS SWITCH XLOOKUP - which is better?Подробнее

The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)Подробнее

XLOOKUP with Multiple Criteria | Advanced Excel Trick | GunjanSharesПодробнее