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...
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...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...



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.