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 […]
Continue readingTag Archives: VLOOKUP
Perform VLOOKUP with Multiple Lookup Values in Three Ways
Welcome to Excel Jet Consult. In this tutorial, we will learn how to perform VLOOKUP with multiple lookup values in three ways. Let’s get started In the caption below, we have a sample data to work with Note, we have list data validation in cells F2:H2. So, we want to return the Sales Total result for Abiola David with States […]
Continue readingVLOOKUP VS. XLOOKUP
Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrate how to use the VLOOKUP and the new XLOOKUP. Enjoy the video
Continue reading