ExcelHow

Tag: Excel MATCH

How to Create Dynamic Drop Down List without Blank in Excel

Excel Examples

November 26, 2023
Excel nested if statements with ranges

Excel Examples, Excel Logical Functions

November 26, 2023
How to Return Cell Address Instead of Value in Excel

Excel Examples

November 5, 2023
How to Get the First, 2nd or Nth Match Using Vlookup/Index/Match

Excel Examples

October 29, 2023
How to Extract a Unique List based on Criteria in Excel

Excel Examples

October 21, 2023
How to Look up Value and Return Adjacent Cell Value in Excel

Excel Examples

July 9, 2023
How to Find the First or Last Positive or Negative Number in a Column/List in Excel

Excel Examples

June 25, 2023
How to Get Row Number From a Vlookup in Excel

Excel Examples

April 25, 2023
How to Transpose Values Based on the Multiple Lookup Criteria

Excel Examples

April 17, 2023
How to Concatenate Text based on unique values in Another Column in Excel

Excel Examples, Excel VBA

April 17, 2023
How to Find the Largest Value in a Column and Return the Adjacent Cell Value in Excel

Excel Examples

April 16, 2023
Convert State Names To Abbreviations

Excel Examples

April 15, 2023
How to Count Only Unique Values Excluding Duplicates in Excel

Excel Examples

April 12, 2023
How To Align Duplicate Values within Two Columns in Excel

Excel Examples, Excel VBA

April 10, 2023
Find Missing Numbers in a Sequence in Excel

Excel Examples, Excel VBA

April 4, 2023
How to Look Up the Lowest Value in A List by VLOOKUP/INDEX/MATCH Functions in Excel

Excel Examples, Excel VBA

April 2, 2023
How to Lookup the Next Largest Value

Excel Examples, Excel VBA

March 29, 2023
How to get nth Match with One Criteria using INDEX/MATCH

Excel Examples

March 27, 2023
How to Find the Last or First Value in a Range Greater Than X in Excel

Excel Examples

March 22, 2023
How to Extract the Column Header of the Largest Value in a Row in Excel

Excel Examples

March 1, 2023