HLOOKUP with multiple criteria (OR/AND logic)

Crispo Mwangi | 12-Aug-17 | Leave a Comment

For some time now, I have looked for a way to look up horizontally duplicate data using (OR/AND) logic. All the attempts to use HLOOKUP to return multiple results using (OR/AND) logic failed. Then I discovered a combination of  INDEX, SMALL, IF and ROW functions that worked like magic. Suppose you have below attendance register and you want […]