Using Excel's XLOOKUP Function

Technology for Teachers and Students May 17, 2021
Video Thumbnail
Technology for Teachers and Students Logo

Technology for Teachers and Students

@techteachersandstudents

About

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

You May Also Like

Upgrade Your Action Footage Today

AI-recommended products based on this video

Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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

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

(848)
$219.99
FREE delivery Sun, Aug 24
Loading...
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

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

(0)
$14.49
FREE delivery Aug 27 - Sep 17
Loading...
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 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)

(2,807)
$181.49
FREE delivery Sun, Aug 10
Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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

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

(3)
$44.99
FREE delivery Thu, Jun 19
Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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

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

(329)
$22.99
FREE delivery Sat, Jun 14 on your first order
300+ bought in past month
Loading...
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
Best Seller

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

(248)
$69.99
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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

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

(0)
$33.08
FREE delivery Sep 3 - 15
Loading...
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

(3,962)
299.00
PrimeFREE delivery Saturday, June 14
500+ bought in past month
Loading...
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 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)

(2,807)
$181.49
FREE delivery Sun, Aug 10