XLOOKUP Express Tour
JasonMorrell
@jasonmorrellAbout
Be the legend in your office. With a focus on Microsoft 365 and maximising productivity, I uncover the useful stuff they hide away and help you navigate around the pitfalls and dead ends so you can slash hours from your everyday tasks. My 5 pillars are Simplify, Streamline, Eliminate. Automate and Educate.
Video Description
An express tour of the XLOOKUP function in Excel. Discover how XLOOKUP consolidates all the best parts of, and overcomes the weaknesses of, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX and IFERROR. 😃 TIME CODES 00:00 Intro 00:34 About our example data 01:24 How to do an XLOOKUP if your lookup value is not in the first column 03:44 How to handle XLOOKUP errors where no match is found 05:34 How to create a genuine database lookup with multiple return values (XLOOKUP + SPILL) 06:57 How to use XLOOKUP with Approximate match (going DOWN to find the closest match) 09:26 How to use XLOOKUP with Approximate match (going UP to find the closest match) 10:42 How to use XLOOKUP for a 2-way lookup (the intersection of matching row and column) Did you get any ideas or inspiration from this video? Share in the comments below and don't forget to click the THUMBS UP button. 😃 SHARE: https://youtu.be/ANWD4gpHtFk 😃 ABOUT THE PRESENTER: Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia. 😃 LET'S CONNECT! https://officemastery.com (free training resources) https://facebook.com/officemastery https://linkedin.com/in/jkmorrell https://youtube.com/JasonMorrell Have a fantastic day!
You May Also Like
Knead-to-Have Baking Essentials
AI-recommended products based on this video
Vacuum Sealer for Food,75Kpa Precision Suction Power 6-in-1 Food Sealer with Digital Timer, Dry & Moist Food Modes, Compact Design with 10 Vacuum Bags & Bulit-in Cutter(Black Sliver)
75Kpa Vacuum Sealer Machine, 6-in-1 Food Sealer with Digital Timer & Dry/Moist Modes, Compact Design, Includes 10 Bags + Built-in Cutter (Silver)
Vacuum Sealer for Food,75Kpa Precision Suction Power 6-in-1 Food Sealer with Digital Timer, Dry & Moist Food Modes, Compact Design with 10 Vacuum Bags & Bulit-in Cutter(Sliver)
Vacuum Sealer Machine,75Kpa Precision Suction Power 6-in-1 Food Sealer with Digital Timer, Dry & Moist Food Modes, Compact Design with 10 Vacuum Bags & Bulit-in Cutter(Sliver)
TRAUSI Instant Read Meat Thermometer, Fast & Accurate Digital Food Thermometer with Backlight, Waterproof & Magnet for Grilling, Cooking, BBQ, Smoker, Baking, and Candy Making Black
ThermoMaven Professional Meat Thermometer Digital, 1-Second Truly Instant Read, NIST Certified Accurate to ±0.5℉, Ultra Bright LED Screen, 100% Waterproof, Motion-Sensing Wake/Sleep, Black
Environet Hydroponic Growing Kit, Self-Watering Mason Jar Herb Garden Starter Kit Indoor, Windowsill Herb Garden, Grow Your Own Herbs from Organic Seeds (Basil)
Herb Garden Planter Indoor Kit 21Pcs Kitchen Herb Garden Starter Kit Growing Kit Including Wooden Box Burlap Pots Soil Discs Gardening Tools Unique Easter Birthday Christmas Gift Ideas for Women Mom
Bonsai Starter Kit – 1x Bonsai Tree | Complete Indoor Starter Kit for Growing Plants with Bonsai Seeds, Tools & Planters – Gardening Gifts for Women & Men
Freenove Ultimate Starter Kit for BBC micro bit (V2 Included), 316-Page Detailed Tutorial, 225 Items, 44 Projects, Blocks and Python Code
ARM & HAMMER Baking Soda Shaker, Dual Sided Easy Pour Dispenser, For Baking, Cleaning and Deodorizing, 340g
3D Spiral Apples Silicone Molds for Baking | Food Grade Mousse Cake Chocolate Molds | Reusable Baking Molds Silicone Shapes (3.46x3.46x2.09in)
The Complete Baking Book for Young Chefs: 100+ Sweet and Savory Recipes that You'll Love to Bake, Share and Eat!
TRAUSI Instant Read Meat Thermometer, Fast & Accurate Digital Food Thermometer with Backlight, Waterproof & Magnet for Grilling, Cooking, BBQ, Smoker, Baking, and Candy Making Black