Excel Forum
Similar Content
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...

Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See two different non-array formula methods for extracting data with four criteria based on criteria in cells and formulas. See the SUM, AND, OR, IF, MAX, VLOOKUP, INDEX, MATCH functions.
This video is in response to:
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods

Got a Question? Ask it Here in the Forum.