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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.