Excel's XLOOKUP and a Magic Trick

preview_player
Показать описание
Welcome to Hey Ivan, a channel where you can ask tech questions. In this video, I honor a request and tell you how to use XLOOKUP. Afterward, I show you a magic trick.

LINKS

CHAPTERS

00:00:00 Introduction
00:00:29 Using XLOOKUP in Excel
00:03:22 It’s time for magic

GOT A QUESTION?

Do you have a tech question? Just shout “Hey Ivan” in the comments.

If you like this video, subscribe — it’s free!

If you know of anyone who could benefit by watching this video, tell them about it and send them a link.

Thanks for stopping by!

~Ivan

  1. Hey Ivan!
  2. Tech
  3. Technology
  4. How To
  5. Excel
  6. XLOOKUP
Рекомендации по теме
Excel XLOOKUP Function 0:25:02

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600

Excel's XLOOKUP and 0:03:54

Excel's XLOOKUP and a Magic Trick

Excel XLOOKUP Function 0:04:14

Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601

XLOOKUP is Magic: 0:02:22

XLOOKUP is Magic: Using XLOOKUP to Generate Multiple Values

XLOOKUP or VLOOKUP 0:04:36

XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833

How to Use 0:13:34

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

Lookup Column with 0:03:30

Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835

Amazing XLOOKUP Formula 0:03:38

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

VLOOKUP or XLOOKUP 0:05:26

VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758

How to Use 0:10:36

How to Use Excel XLOOKUP and XMATCH Functions

XLOOKUP Function in 0:00:53

XLOOKUP Function in Excel

3-Way Lookup Adding: 0:03:56

3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602

Dynamic Range in 0:05:42

Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836

Excel Pro Tricks: 0:00:46

Excel Pro Tricks: XLOOKUP to return Multiple Columns and Rows in Excel formula with XLOOKUP Function

XLOOKUP in Excel 0:16:40

XLOOKUP in Excel Tutorial

How to use 0:03:41

How to use the XLOOKUP function in Excel

XLOOKUP with Multiple 0:03:24

XLOOKUP with Multiple Conditions

XLOOKUP - Return 0:07:56

XLOOKUP - Return Multiple Columns (Values) in Excel

Excel Two-Way XLOOKUP 0:04:04

Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial

XLOOKUP in Excel: 0:08:47

XLOOKUP in Excel: Why it Rocks and Comparison to VLOOKUP and Index Match

Series Discount Excel 0:08:55

Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643

Xlookup In Excel: 0:03:33

Xlookup In Excel: Explained In 3 Minutes

INDEX Function Beats 0:00:52

INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14

Excel Formula for 0:03:13

Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603

Комментарии
Автор

I think that might have been 2 magic tricks! As usual, another helpful, well-explained, and useful tip!

hillaryjanikula
Автор

I enjoy your videos and always learn a lot. Thanks for adding even more fun at the end with your magic. 👍

amycox
Автор

Great stuff Ivan - enjoyed our time and getting to meet you at the ABA tech show.

samuellincoln