Excel Dynamic Array Functions - Video#10: Xlookup Vs Vlookup - Which one would you choose?
Channel: AAA Excel’s Power
Date: 26/12/2020

Excel Dynamic Array Functions - Video#10:
1- Exact match 0:57
2- From right and left 4:17
3- Horizontal search 5:28
4- Full row 6:54
5- Approximate match 10:23
6- Using wildcards 13:35
7- If not found 16:15
8- Last to first or reverse search 18:34

Hello and welcome to a new video discussing dynamic array functions, video number 10
No need to remind you that dynamic array functions are working only with office 365, if you are using any other version of the excel, you won’t be able to practice the exercise in this video
In this video we will compare between Xlookup & Vlookup functions and will ask you to decide which one to choose in which situation

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if

To Download the excel file:
https://drive.google.com/file/d/1t5G5TVVglPOmOgdCzcKFmNfivmlpUhwQ/view?usp=sharing

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef