LOOKUP Filter Truth Table

This article will guide you on different ways to use operators in filter criteria in LOOKUP()