XLOOKUP Case Sensitive in Excel | Match Text Exactly

In this video, we create a case sensitive XLOOKUP formula using the EXACT function to match case of the lookup value, and matching value in the lookup column.
Learn the best 150 Excel functions with Advanced Excel Formulas amzn.to/3Rg87Go
With XLOOKUP in Excel it is easy to create a case sensitive lookup formula. This powerful Excel formula allows the use of the EXACT function and can match the result of the logical value to its lookup value of TRUE.
Find more great free tutorials at; www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1

[@IvanCortinas_ES]

As always, very useful for the company. To take these types of cases into account. Thanks Alan.

[@Computergaga]

My pleasure!

[@user-mx2pv8bb9m]

Oh so good, I learnt this for first time. Lot of Thanks

[@Computergaga]

You're welcome 😊

[@PaulEBrownbill]

Thanks for the video, very informative Paul

[@Computergaga]

Thank you, Paul.

[@lynxwomancat]

3:57 DST USA. 😊 fantastic, thank you!!!! I never knew this!!

[@Computergaga]

Awesome! My pleasure.

[@Luciano_mp]

Good...Thank you Alan.

[@Computergaga]

Welcome!

[@nadermounir8228]

Thank you Alan for this interesting video 📹 👍

[@Computergaga]

Very welcome

[@nigilv.d4237]

Great

[@Computergaga]

Thank you 👍🏼