How to use XLOOKUP in place of Vlookup. This enables right-to-left searching..much more versatile.

Share this & earn $10
United Computers
Published at : 24 Sep 2021
77 views
8
0

This video demonstrates and explains the use of XLOOKUP, a relatively new formula introduced by Microsoft.
Importantly it allows searching for data right-to-left in addition to the usual left-to-right search.
BEST VIEWED FULL SCREEN, HIGH RES.


Screen recording software: Camtasia for Windows 18.00

Hardware: Dell 24 2700 all-in-one 1tb hd 8mb RAM 23.8" touch screen

Operating system:Windows 10



Visit us at : http://unitedcomputerconsultants.com

Tweet us at: http://twitter.com/geoffhudson7

Microsoft OfficeExcelWord

Nastya and Watermelon with a fictional story for kids

Nastya and Watermelon with a fictional story for kids

Polite English - WANT & WOULD LIKE

Polite English - WANT & WOULD LIKE

HOSH & 1979 Feat. Jalja - Midnight (The Hanging Tree) [Lyric Video]

HOSH & 1979 Feat. Jalja - Midnight (The Hanging Tree) [Lyric Video]

Heartstrong and Lifelong

Heartstrong and Lifelong

Every time my Friend goes AFK.. I add a Custom Mod

Every time my Friend goes AFK.. I add a Custom Mod

QUICKLY - JOHN LEGEND FEAT BRANDY

QUICKLY - JOHN LEGEND FEAT BRANDY

Introduction to Envision

Introduction to Envision

2. Rethinking Adam Smith

2. Rethinking Adam Smith

VARIED

VARIED

Travelling To Sweden For A Toilet 😂

Travelling To Sweden For A Toilet 😂

A Short While

A Short While

Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model - Part 1

Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model - Part 1

Where Would I Be (feat. Hope Darst) // The Belonging Co

Where Would I Be (feat. Hope Darst) // The Belonging Co

Delivery Man - A Certified Short Film

Delivery Man - A Certified Short Film

Old MacDonald Had A Farm - 3D Animation English Nursery Rhymes & Songs for children

Old MacDonald Had A Farm - 3D Animation English Nursery Rhymes & Songs for children

Slaughter To Prevail - DEMOLISHER

Slaughter To Prevail - DEMOLISHER

Calculus - Continuous functions

Calculus - Continuous functions

Strengthened-Koinonia With Apostle Joshua Selman

Strengthened-Koinonia With Apostle Joshua Selman

Lately

Lately

Colorations® BioColor

Colorations® BioColor

chromeSteel

chromeSteel

10 Habits of Healthy People - How To Live Longer

10 Habits of Healthy People - How To Live Longer

A Practical Introduction to CT

A Practical Introduction to CT

Barbell Hip Thrust - Correct Pelvic Position and Load Tips | Tim Keeley | Physio REHAB

Barbell Hip Thrust - Correct Pelvic Position and Load Tips | Tim Keeley | Physio REHAB

Metroid Dread? More like Meh-troid | Cannot be Tamed

Metroid Dread? More like Meh-troid | Cannot be Tamed

easily - bruno major || lyrics

easily - bruno major || lyrics

TRAPCODE | What's New in Trapcode Particular 6

TRAPCODE | What's New in Trapcode Particular 6

OPT Phrasal Verbs | English Phrasal Verbs for OPT with Meaning & Example Sentences | SSC CGL

OPT Phrasal Verbs | English Phrasal Verbs for OPT with Meaning & Example Sentences | SSC CGL

What Really Happened at the Arecibo Telescope?

What Really Happened at the Arecibo Telescope?

Ελληνοφρένεια 9/9/2021 | Ellinofreneia Official

Ελληνοφρένεια 9/9/2021 | Ellinofreneia Official

I Tried The Most Potent CBD Oil - Here's What Happened

I Tried The Most Potent CBD Oil - Here's What Happened

تحدي الوجبة المفتوحة (لاتفوتكم خلطتنا 🧨🔥) Open meal challenge

تحدي الوجبة المفتوحة (لاتفوتكم خلطتنا 🧨🔥) Open meal challenge

Choices And Their Consequences - Anthony Ndung'u

Choices And Their Consequences - Anthony Ndung'u

SIDEMEN WHO WANTS TO BE A BILLIONAIRE

SIDEMEN WHO WANTS TO BE A BILLIONAIRE

Ritt Momney - Something In General

Ritt Momney - Something In General

Pigeon John - "The Bomb" [Official Video]

Pigeon John - "The Bomb" [Official Video]

Certainly.io explainer video

Certainly.io explainer video

THE BEST SWEET POTATO PIE RECIPE | EASY OLD-FASHIONED THANKSGIVING 2021 RECIPE

THE BEST SWEET POTATO PIE RECIPE | EASY OLD-FASHIONED THANKSGIVING 2021 RECIPE

Every Person Dissed in 800 Fatz - "Smooth Style"

Every Person Dissed in 800 Fatz - "Smooth Style"

Cellphone Daddy Mommy Song + More | Mother Goose Club Nursery Rhyme Cartoons

Cellphone Daddy Mommy Song + More | Mother Goose Club Nursery Rhyme Cartoons

卿Mittens - Too Easily

卿Mittens - Too Easily

seem

seem

The market has internalized many forms of inflation: Barclays' Gapen

The market has internalized many forms of inflation: Barclays' Gapen

Belly - Maintain (feat. NAV)

Belly - Maintain (feat. NAV)

What is the difference between debtors & creditors?

What is the difference between debtors & creditors?

15 Smart Ways To Communicate Complex Ideas

15 Smart Ways To Communicate Complex Ideas

John Kirwan to show pride of Auckland to Lions fans

John Kirwan to show pride of Auckland to Lions fans

SHE KNEW IT WAS BROKEN RIGHT AWAY

SHE KNEW IT WAS BROKEN RIGHT AWAY

Grease - Hopelessly Devoted to You (Lyrics) but now there's nowhere to hide since you

Grease - Hopelessly Devoted to You (Lyrics) but now there's nowhere to hide since you