3D Cross Tab Search using XLOOKUP

Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to create 3D Cross Tab Search using XLOOKUP function. Let’s get started   Video   Sample Data In the screenshot below, we’ve got a sales data that contains Total by Account Manager and Month. XLOOKUP Formula Our goal is to group all the […]

Continue reading