Using Excel's XLOOKUP Function
Technology for Teachers and Students
@techteachersandstudentsAbout
I'm an educator and educational technology enthusiast. The videos on this channel will help you learn how to use a wide range of computer software applications, educational websites, and other technology tools. Watch for a new video every Monday! Connect with me on the services you see below in the Links section.
Video Description
Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP and HLOOKUP functions and can help you quickly search a huge spreadsheet based upon information you have and it will find and return information that you're looking for. This is a powerful function that will become more and more important as it effectively replaces the older lookup functions. Watch my entire playlist of Excel tutorials: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's the practice file for this video (copy/paste it into browser): http://bit.ly/excelxlookup #exceltutorial #excel #xlookup
Upgrade Your Action Footage Today
AI-recommended products based on this video
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera
AKASO V50 Elite 4K60fps Touch Screen WiFi Action Camera Voice Control EIS 131 feet Waterproof Camera 8X Zoom Remote Control with with 64GB U3 MicroSDXC Memory Card Global Recycled Standard
Selfie Stick, 7 Section Adjustable Action Camera Extension Pole with 1/4in Thread and Screw Hole, 23.5 to 120cm Portable Extension Rod for Panoramic Camera
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)
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera
Wireless Lavailer Microphone for iPhone, Android, Camera, iPad, USB C, 4 in 1 Professional Mini Microphone with Noise Reduction, Wireless Mic for Video Recording, Vlog, YouTube, TikTok
3-in-1 Professional Wireless Lavalier Microphone for iPhone, Android, Camera – 328ft Range, 20H Battery, Wireless Microphones, Noise Canceling for Recording, Live Streaming, YouTube, TikTok
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera
2200mAh / 8.14Wh Battery for Garmin E1GR, E1GRVIRBELITE, E2GR, E2GRVIRBELITE, VIRB, VIRB Elite, Virb Elite Action HD Camera 1. PN:Garmin 010-11599-00, 010-11654-03
DJI Osmo Action 4 Standard Combo, 4K/120fps Waterproof Action Camera with a 1/1.3-Inch Sensor, Stunning Low-Light Imaging,10-bit & D-Log M Color Performance, Long-Lasting 160 Mins, Outdoor Camera