XLOOKUP Function Explained by 2x Excel Esports Champion Andrew Ngai

preview_player
Показать описание
Why is XLOOKUP cool? How does it work? How does it help in Excel Esports tasks?

You can use the XLOOKUP function to find things in a table or range by row. Andrew Ngai, the winner of the recent Excel Esports All-Star Battle AND FMWC Open 2021, explains it all in this video.

0:00 How does XLOOKUP work?
01:00 Why is XLOOKUP cool?
02:23 XLOOKUP spotted in All-Star Battle
------------------------------------------------------

For more updates, follow us on social media:
  1. Financial Modeling World Cup
Рекомендации по теме
XLOOKUP Function Explained 0:03:45

XLOOKUP Function Explained by 2x Excel Esports Champion Andrew Ngai

XLOOKUP with Multiple 0:03:24

XLOOKUP with Multiple Conditions

XLookup Function in 0:10:49

XLookup Function in Excel | What Can do Excel for You?? | Two Way Xlookup Function

Xlookup Function 0:00:50

Xlookup Function

Xlookup function 0:11:08

Xlookup function

XLOOKUP | Masterclass 0:16:15

XLOOKUP | Masterclass on XLOOKUP | Excel 365 | Excel 365 Functions | All in One Lookup Function

XLOOKUP & XMATCH 0:19:58

XLOOKUP & XMATCH New Excel Function Explained In Detail

XLOOKUP in Excel 0:14:00

XLOOKUP in Excel in Hindi | XLOOKUP in Excel | XLOOKUP Formula | Excel 365 in Hindi | Learn XLOOKUP

XLOOKUP vs VLOOKUP 0:11:27

XLOOKUP vs VLOOKUP & MATCH by Chris Menard

Xlookup function in 0:10:02

Xlookup function in EXCEL365

How to use 0:16:02

How to use Xlookup function (Replace Vlookup, Hlookup and Match & Index)

Xlookup 5 New 0:13:32

Xlookup 5 New and Improved Examples with Double or Nested Xlookup

XLOOKUP function for 0:10:31

XLOOKUP function for creating Dynamic Named Ranges in Excel

FREE ADDING XLOOKUP 0:05:47

FREE ADDING XLOOKUP Function | Problem Solved | Excel | Hindi

Xlookup Function in 0:19:50

Xlookup Function in Excel | Xlookup Tutorial in hindi | Xlookup Complete Tutorial with Example

XLOOKUP Retires VLOOKUP 0:46:31

XLOOKUP Retires VLOOKUP and More

ADD & USE 0:20:22

ADD & USE XLOOKUP Function in Excel Telugu || Run on Ms-Office All Versions ||computersadda.com

Excel Formula for 0:04:29

Excel Formula for Two Way Lookup

XLOOKUP: NSE Option 0:02:26

XLOOKUP: NSE Option Chain Example

How to use 0:03:10

How to use Nested Xlookup to build two-way lookup in Microsoft Excel | Learn in 5 Minutes

Learn Excel XLOOKUP 0:13:24

Learn Excel XLOOKUP Inside Out - 14: Lookup Both Text & Number

Excel New FUnction 0:05:35

Excel New FUnction XMATCH,XLOOKUP and Sort function by learning center

Webinar # 33 0:42:42

Webinar # 33 - XLOOKUP and LET Function - Dynamic Array Formulas in Microsoft Excel (Fundamentals)

Using CHOOSE and 0:05:51

Using CHOOSE and XLOOKUP Functions to Choose & Lookup Values Across Different Workbooks

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

Fast and easy to understand explanation. Hoping this becomes a series of similar quick clips. It would also be neat to have a video compiling pet peeves, favourite formulas, pro tips from the top competitors.

maddyline
Автор

think its easier to name a range "lookupCol" in row1 of the column and then do
=iferor(vlookup(value, fullTable, column("lookupCol"), false), "n/a")
. its annoying to have to use two different column ranges with xlookup assuming you set your key value pair properly as in the "name" column. wouldnt have the need to lookup via "birthday"

horschj