No longer use the Vlookup function but rather...
A while ago, I launched a survey to see how many of you use the various search functions in Excel.
It turns out that most of you who responded to the survey use the Vlookup function, and in this video, I'm going to try to convince you to use something other than Vlookup.
That's not all; we're also going to optimize the Vlookup function to make it as dynamic as possible.
So, hang on tight because we'll cover:
how Vlookup works, the index and equal formula, and finally the Xlookup function.
00:00 Intro
00:56 Vlookup
04:46 Index + Equal
06:22 Xlookup
Website: https://www.tutoderien.com
Subscribe to the channel and we'll see you again for the next video.
#TutoDeRien #ExcelTraining #ExcelLookup