I'm finding the Xlookup formula keeps on becoming a superpower of all lookups. In this tutorial I'll show you how to use an Xlookup twice to lookup multiple columns.
If you are new to Excel and are struggling to understand the basics let me share with you a downloadable guide that will help. Access your Excel Quick Start Guide here.
The new Xlookup formula is a brand new formula that can replace the use of Vlookup. It searches down or across to find the value you want and then returns a value within the return range. Take a look at my video to see it in action.
I'm excited to show you the first views of a new feature ofcreating Slicers in Google Sheets. Compare this to a previous post I did on Excel slicers. Slicers allow you to filter you data in easy to manage buttons.