Xlookup with Multiple Criteria | Microsoft Excel | +1~412~567~0408

Gautamsharma29 Feb, 2024Event/Party Planner

All my attempts to use HLOOKUP to return multiple results using (OR/AND) logic failed until I discovered a combination of INDEX, SMALL, IF and ROW functions that worked like magic. Suppose you have below attendance register and you want to look up and return all PRESENT staff on 01?07?2016.