1. Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

    Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

    4
    0
    15
  2. How to use Excel Index Match (the right way)

    How to use Excel Index Match (the right way)

    5
    0
    43
  3. Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells

    Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells

    4
    0
    23
  4. Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    3
    0
    14
  5. Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

    Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

    3
    0
    19
  6. Excel Conditional Formatting the Lookup result in data table (Index Match)

    Excel Conditional Formatting the Lookup result in data table (Index Match)

    4
    0
    9
  7. Excel Simple Dependent Drop down List based on numbers (Index without match)

    Excel Simple Dependent Drop down List based on numbers (Index without match)

    4
    0
    12
  8. Excel DGET Function Solves 2 of Your VLOOKUP Problems

    Excel DGET Function Solves 2 of Your VLOOKUP Problems

    3
    0
    26
  9. Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX

    Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX

    4
    0
    5
  10. Return Multiple Match Results in Excel (2 methods)

    Return Multiple Match Results in Excel (2 methods)

    3
    0
    6
  11. Excel Lookup to Return Multiple Values with FILTER Function

    Excel Lookup to Return Multiple Values with FILTER Function

    3
    0
    64
  12. Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

    Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

    6
    0
    9
  13. Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    3
    0
    8
  14. Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    3
    0
    15
  15. Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    4
    0
    9
  16. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    14
  17. Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    3
    0
    20
  18. Left Lookup in Excel with XLOOKUP (Made Easy)

    Left Lookup in Excel with XLOOKUP (Made Easy)

    4
    0
    16
  19. Excel Dynamic Chart with Drop down List (column graph with average line)

    Excel Dynamic Chart with Drop down List (column graph with average line)

    3
    0
    8
  20. How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

    How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

    3
    0
    40
  21. FREE FULL COURSE Learn MS Excel and Data Analysis

    FREE FULL COURSE Learn MS Excel and Data Analysis

    34
    7
    67
  22. Excel FILTER Function TRICK for Non Adjacent Columns

    Excel FILTER Function TRICK for Non Adjacent Columns

    4
    0
    81