Introduction Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to use FILTER Dynamic Array Function to perform the same operation that lookup family functions such as VLOOKUP, INDEX MATCH and XLOOKUP will perform. Let’s get started Definition of FILTER Function & Syntax The FILTER Function filters a range or an array Syntax    […]