Liked, that was very informative between the two functions. At first I was like where was the Lookup function all these time in my life where I can search left or right. Then, when you point out the possible error of Lookup function, I see why people just stick with the regular Vlookup vs Vlookup + Choose (or Match/Index) for the reverse Vlookup.
be warned, the lookup function can get very screwed up based on the formatting of the cells...I have seen the lookup feature give incorrect searches and it can get very frustrating.
how does this dude know everything about every subject.
agree lmao, he helped me in Calculus, Science, and ICT ahhahahahahahah
maoooooo he be that nerd kid in every class
Liked, that was very informative between the two functions. At first I was like where was the Lookup function all these time in my life where I can search left or right. Then, when you point out the possible error of Lookup function, I see why people just stick with the regular Vlookup vs Vlookup + Choose (or Match/Index) for the reverse Vlookup.
Thank you. the sorting issue explains exactly my question!!
I tapped on this video without realising it was you and holy shit this guy is a god!!!
Man basically does all my collage assignments for me
except spelling: college
Simple and well explained.
you are a genius
Thank you! I was getting errors and sorting the input fixed it! It was a list of names so I had to put them in alphabetical order....
2:40 why did u include the "phone" coloumn but we r looking for the age?
Thanks this really helped
why it doesn't work when you select column first from the left ?
thanks a lot bro
thank you
what about if the information was in another seperate table
be warned, the lookup function can get very screwed up based on the formatting of the cells...I have seen the lookup feature give incorrect searches and it can get very frustrating.
AND frist to LIKE
First
*clapping*