XLOOKUP for Horizontal & Vertical mapping in excel

Raw data for excel practice download : drive.google.com/open?id=1nGt...
This video shows you XLOOKUP for Horizontal & Vertical data mapping in MS Excel Office 365. This is two way lookup type.
Excel Tips & Tricks : • Intermediate Excel tip...
Excel Analysis : • Data analysis techniqu...
Excel Functions : • Excel important formul...
Excel DAX formulas : • Dax formula in excel |...
Excel for Job Interview : • Data cleaning in excel...
Excel 365 Features : • Excel new features 201...
Excel 2019 Features : • Playlist
Mobile Excel Tutorial : • Mobile Excel Tutorial ...
Creative & Advanced charts : • Creative & Advanced Ex...
Excel Automation : • VBA & Macro training i...
450 Excel functions with examples : • Learn 450 EXCEL FORMUL...
50+ Important excel functions with examples : • 50+ excel IMPORTANT FO...
Top 60 widely using most popular excel functions : • Top 60 MOST POPULAR ex...
Different types of MIS reports & dashboard creation : • MIS reports & Dashboar...
HR MIS dashboard using Power Pivot : • Headcount report in ex...
#excel
#learnexcel
#exceltutorial
#microsoftexcel
#microsoftexceltutorial
#msexcel
#excelhelp
#ExcelSpreadsheets
#SpreadsheetHelp
#Spreadsheet
#excelexperts
#ExcelSpecialists
#excelsupport
#MSOffice
#Xlookup
Thank you for watching this video !!

[@Uriel_Soberanes]

Excellent!, straight to the point!!!! Thanks

[@ExcelAZ]

You're welcome 💐

[@lzero1166]

I am very grateful to your video, thank you for your contribution!!

[@ExcelAZ]

Glad it was helpful!

[@chandramouli3322]

Excellent bro... very simple but powerful formula ......... Thank you.

[@ExcelAZ]

So nice of you

[@shubhabratadey]

Awesome trick..👍

[@ExcelAZ]

Cheers ❤️

[@babai9277]

Wow😮😮...
Its amazing 🤩

[@ExcelAZ]

Thank you so much 😀

[@bashiblues6297]

broo..many many thanks

[@ExcelAZ]

💖💐💝

[@akashdeepsingghh]

can you please share the music link or something similar, i just love it

[@ExcelAZ]

There is no link. But it is available is RUclips creators library.

[@Jessemfguire]

Why when I do the same thing it returns the full row of information instead of just the single cell value? Hmm??

[@ExcelAZ]

What Excel version do you use?

[@jakkfamily61]

Ditch the music

[@ExcelAZ]

🧐

[@belaygebreyohanes9363]

you solved my nightmare

[@ExcelAZ]

Glad to hear! 💝👍💝

[@ExcelAZ]

WATCH NEXT - Latest excel functions tutorial | Download excel file for your practice: ruclips.net/p/PLZnHzQfaP-kO1wJOnCEgJsjGeNFqbV6S9

[@babai9277]

How to use if not found in double xlookup formula

[@ExcelAZ]

I will upload a video for the same as soon as possible. Thank you!

[@babai9277]

@@ExcelAZ Thanks ❤️..... 💥

[@ExcelAZ]

👍

[@BhauMH25]

what if there are multiple rows with branch 3?

[@ExcelAZ]

🧐

[@nittalpatel1206]

This formula doesn't work in my xls. Can u pls help

[@ExcelAZ]

May I know your excel version?

[@nittalpatel1206]

@@ExcelAZ its office 365

[@ExcelAZ]

Okay. What kind of error did u get?

[@nittalpatel1206]

@@ExcelAZ i got error like #value

[@ExcelAZ]

Reapply formula