ExcelHow

Author: scott

VLOOKUP with Two Lookup Tables

Excel Examples

July 6, 2021
VLOOKUP with Multiple Lookup Values

Excel Examples

July 5, 2021
VLOOKUP Data by Date

Excel Examples

July 3, 2021
VLOOKUP – Retrieve Data from Another Workbook

Excel Examples

July 1, 2021
VLOOKUP – Retrieve Data from Another Worksheet

Excel Examples

June 30, 2021
Case Sensitive Lookup with SUMPRODUCT and EXACT

Excel Examples

June 29, 2021
Basic Usage of INDEX & MATCH – Case Sensitive Lookup

Excel Examples

June 28, 2021
Basic Rates Calculation by VLOOKUP Based on Weight Band

Excel Examples

June 23, 2021
Basic Grade Calculation by VLOOKUP Function – Approximate Match

Excel Examples

June 21, 2021
Basic Discount Calculation with VLOOKUP Function

Excel Examples

June 19, 2021
Basic Usage of INDEX & MATCH – Exact Match

Excel Examples

June 17, 2021
Basic Usage of INDEX & MATCH – Approximate Match

Excel Examples

June 16, 2021
Approximate Match with Multiple Criteria by INDEX & MATCH

Excel Examples

June 13, 2021
Average per Week by Formula in Excel

Excel Examples

June 8, 2021
How to Statistic Pass 4 Out of 5 Rounds in a Competition by Excel Functions

Excel Examples

June 7, 2021
Average with Multiple Criteria in Excel

Excel Examples

June 5, 2021
Average of Top N Values in Excel

Excel Examples

June 4, 2021
Average the Last N Numeric Values in Excel

Excel Examples

June 3, 2021
How to Average Last N Values in Multiple Columns

Excel Examples

May 30, 2021
How to Average Ignore Zero Number

Excel Examples

May 28, 2021