ExcelHow

Tag: Excel MATCH

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
How to Count Cells Not Equal to One of Many Things in Excel

Excel Examples

October 9, 2020
How to Count Duplicate Values Only Once in A Range in Excel?

Excel Examples

August 27, 2020
How to Compare Two Columns for Differences in Excel

Excel Examples

August 15, 2019
How to Lookup Values from Right to Left in Excel

Excel Examples

April 15, 2019
How to Get Cell Address of Max or Min Value in a Range in Excel

Excel Examples

January 11, 2019
How to Extract a Unique Distinct List from a Column in Excel

Excel Examples

January 10, 2019
Find Closest Value or Nearest Value in a Range in Excel

Excel Examples

September 14, 2018
Convert Weekday Name to Number

Excel Examples

August 14, 2018
Finding the Max and Min value in an Alphanumeric Data

Excel Examples

July 11, 2018
How to Find the Maximal or Minimal String Based on Alphabetic Order

Excel Examples

May 23, 2018
How to get first match that cell contains one of several values in a range

Excel Examples

December 23, 2017
How to Extract a List of Unique Values from a Column Range

Excel Examples

December 16, 2017