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

Download Excel Start File https://people.highline.edu/mgirvin/Y...

Download file: https://people.highline.edu/mgirvin/E...
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

Extract Records (data) With Multiple Criteria Helper Column

• #science_technology
• #excel
• #2007
• #2010
• #excelisfun
• #mike
• #gel
• #girvin
• #highline
• #community
• #college
• #slaying
• #dragons
• #see
• #two
• #different
• #non_array
• #formula
• #methods
• #for
• #extracting
• #data
• #with
• #four
• #criteria
• #based
• #on
• #in
• #cells
• #and
• #formulas
• #sum
• #and
• #or
• #if
• #max
• #vlookup
• #index
• #match
• #functions
• #magic
• #trick
• #758
• #extract
• #data
• #with
• #two
• #criteria
• #formula
• #methods
• #records
• #data
• #multiple
• #helper
• #column