How to use XLOOKUP to Create Dependent Drop-Down Lists in Microsoft Excel
Teacher's Tech
@teacherstechAbout
🌟 This is the channel where tech finally makes sense! I'm Jamie, an avid tech enthusiast and educator, and I'm here to make your journey into tech a whole lot easier. Forget complicated jargon and confusing tutorials. I make beginner-friendly videos that explain tech concepts in plain English, step by step. In today's fast-paced world, the right tech tools can be a game-changer. That's why I'm here! I break down important business and education apps into simple steps, so you can unlock their power and boost your productivity. If you're ready to get started with tech without the overwhelm, make sure to subscribe to my channel 💡
Latest Posts
Video Description
In this Microsoft Excel tutorial, I will show you how to create dependent drop-down lists using the XLOOKUP function. This can be done without having a filtered list. Using Data validation and the XLOOKUP in the source you can avoid having to create a list on another part of your sheet and you can copy it down. 0:00 Introduction 1:27 Data Validation 2:09 XLOOKUP filtered lists 4:20 Data Validation with a filtered list 6:19 XLOOKUP function inside Data Validation (no filtered list) 7:48 Adjusting cell reference Practice Sheet: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERTMA9dpMd1JsRtAiZb7nxYBgNq3C7sx96psF_rCn3vZrw?e=aGj7LZ Dependent Drop-Down Lists using the INDIRECT function: https://youtu.be/oYF162_Cmwc
Up Your Gear Game
AI-recommended products based on this video
SmallRig NATO Clamp to Quick Release Plate for Arca-Swiss, Built-in NATO Clamp, Lightweight and Easy to Carry, Compatible with Tripods for Arca-Type - MD4857
koolehaoda Professional Gimbal Head Tripod Head Aluminum Alloy Heavy Duty 360° Panoramic with Arca-Swiss Standard 1/4 inch QR Plate for DSLR Cameras up to 55.11lbs/25kg. (GH-3)
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)
NEEWER Zf Handgrip L Shape Grip for Nikon Z f, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle & Aluminum Shutter Button Cap, Compatible with Arca Swiss Tripod Fluid Head, CA073
