Excel VLookup Formula in 8 Minutes [VLookup in Excel]
Register now for the webinar - bit.ly/3KPBiNq
A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.
FALSE searches for the exact value in the first column.
Multiple Worksheet interconnected VLOOKUP()
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to Vlookup in Excel
00:14 Interworksheet VLookup in Excel
00:58 How to use Interworksheet VLookup in Excel
08:01 How to use Text to Number in Excel
A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.
FALSE searches for the exact value in the first column.
Multiple Worksheet interconnected VLOOKUP()
Double vlookup in Excel
Excel VLOOKUP Formula with Multiple sheets | Vlookup in Excel in Hindi
To watch more videos visit: www.excelsuperstar.org/
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
Пікірлер: 912
Click here for Excel Basic to Pro Course: bit.ly/34GhsCM
@Tyagi423
11 ай бұрын
Hi
Ya ALLAH har insan kamyab ho har insan ko sehat izat or kamyabi ata farma tohi Malik hay meray mola tohi hay bus.
@vikascharan4869
2 жыл бұрын
kya bakwas kar raha hai
@aryan_proud_kafir
2 жыл бұрын
stop your non-sense bullshit
@arfanali6375
2 жыл бұрын
Ameen sumameen
@faizancielo
2 жыл бұрын
Ameen 😇 🤗
@parveenkumar-is3km
2 жыл бұрын
Allah se mangna band kro. Khud koshish kro insano ke bhle ke liye.
Thanks for the knowledge of Vlook up. The way u teach is fantastic.
Great video, great content, just simple and to the point, great voice to listen too: THANK YOU 😊
Beautiful sportive presentation. This makes "Learning is Fun"
3:56 the way you give confidence to us sir is excellent,by the way I'm your new subscriber and student.
why would anyone give this a thumbs down? Really good job and thanks for providing the accompanying excel files to practise with.
@bubblegum6701
3 жыл бұрын
The title is in English and the video is not
@varundas9723
3 жыл бұрын
I GUESS FANS OF CARDI B😂
@Paji_Vlogger
3 жыл бұрын
Samaj aara ha kya tuje..jo gyaan baat rha😂
@harshitrastogi1820
2 жыл бұрын
Do you know hindi
@aryan_proud_kafir
2 жыл бұрын
@@bubblegum6701 you haven’t read the whole title, vlookup in Hindi
Am in love with Ur explaination, beautifully explained sir, thank you so much........
Kya samjhaya hai sir. Salute🙋 Kaash aap mere teacher hote, aap jaise teacher kismat walo ko milte hai.
Woww just love the way you explain !!! Amazingg
Good explanation,, felt like hearing cricket commentary.... which created more interest to watch this video.
The way you explain things is just awesome, you got lovely voice. God bless you.
Thank you brother. Your way of presentation and diction is amazing. Keep up the good work!
I loved the way you explained this! So patiently, step by step! keep it up :)
@ExcelSuperstar
5 жыл бұрын
Keep going Kashish Sharma 👍
@SanaKhan-zd3rp
2 жыл бұрын
@@ExcelSuperstar Hello Sir, I'm pressing F4, but the dollar sign is not available.. what should I do now.
@alaudinjami6936
2 жыл бұрын
@@SanaKhan-zd3rp press Shift+4 (numeric 4 key)
Thanks sir... And your voice is awesome 🌟 🌟
Superb, got right solution here. Good explanation skill, Thank you Sir
I was here for a vlookup refresher course, need to use it after 11 years in my job. And your video and voice is so good that loved it.
Absolutely, no words, thanks from Bangladesh
@ANOOPS70
6 жыл бұрын
sadiqur rahman kzread.info
Great.......... thank you Dost :)
Superb video for beginners. Thanks a lot.
solved my problem after browsing videos for 3-4 hours - Crisp and Clear - thanks
Bhai I think you also dub for Hollywood movies😀.Voice clarity is amazing
Very helpful video... 👍
@jitendrabchaudhary3106
5 жыл бұрын
Only for beginner
Amazing Voice explations. Thanks you so much and god bless you brother.
Just after watching I've subscribed your Chanel sir,amazing style of teaching.
do din se dimag khrab kr raha tha smjh me nahi aa raha tha . aapke smjhate hi smjh aa gya. thank u sooo much sir
@ExcelSuperstar
6 жыл бұрын
Thank u Manish
@ManishKumar-om2wf
6 жыл бұрын
Excel Superstar welcm sir
best teacher
@poonamkaushik3574
7 жыл бұрын
agree
@JayPrakash-baghel
6 жыл бұрын
Nice video sir It is very very nice
@jayantiborgaohain9518
6 жыл бұрын
+Jayanti Borgaohain hpkkk
@jayantiborgaohain9518
6 жыл бұрын
+Jayanti Borgaohain hih$&dh$&$&&&$&$*#$&^fhfh$$h$&fj$rhj$j%&$&fr*&&d
@afzalahsan20
5 жыл бұрын
aap study ki ho to mujhe bhi learn kra do yaar 9304371455
very good job. i liked the way you explaining it. so nicely you respecting each and every words, text, formula , function. its like it all has life. loved it. last but not least , u got very good voice with humble way of presenting it. i can see your true nature and a very polite and good personality in you. Rounds of applause for you.
You are a legend for corporate people. Thank you brother don't stop making such videos they are very helpful.
Great sir lagta hai aap salman khan ke faan hai
@ExcelSuperstar
6 жыл бұрын
Right Anuj Chauhan #Race3
@himanshusharma-iu6bf
5 жыл бұрын
Kaise bey?
@Chauhankd94
5 жыл бұрын
मुल्ले के फैन से कुछ नही होता अनुज भाई अपने भाई की जुबान पर तो सरस्वती माँ विराजमान है बस...⛳️ 😍
Sir aap k jesa genuine video koi nahi banata .... Thnks a lot
Xlent, i hv done this in 2006 while i was supervisor in Tathya dotcom, since den i forget, now i revised and got d answar, txns
The way u r talking... just amazed me.... presentation was awesome....and voice... just Excel-ent...
Nicely explained buddy... With core examples.. Keep it up & teach everyone by making new videos.
Wonder Full Explanation, Very Very Thank You for such Brilliant Efforts Keep it Up SIR.
Amazing video sir...nd Ur teaching method is fabulous.. it's really working!!"thanku so much"
you are megician... the way you teaching is awesome..... fun with learn...great man
The way you've taught, was fantastic!!!!❤️❤️❤️❤️
Thx a lot sir, I like so much your teaching method & also good teaching skills to understand front of candidate.
You r truly immensely good the way your explanation....this is it
VLOOK UP IS A GREAT TOOL TO DO HOUR OF WORK IN SECONDS. THANKS FOR YOUR TUTORIAL VIDEO
Sir mesmerized by your teaching, loved it all through, and don't forgot to subscribe you. Thank u sir, to made my job easy.
Bro....your way of teaching is awesome!
Amazing Video. Wouldn't have learnt easier than this!
What a voice and what a way of teaching... Thanks Sir
बहुत ही शानदार वीडियो एवं आपका तरीका भी उससे ज्यादा शानदार है। आप सच में एक अच्छे टीचर है।
thanks for such teaching very very help full for those who dont have time to go to any coaching centre n all
After long time I have learned vlookup formula which I have forgot the formula before thanks a lot its a very good method of teaching......
very nicely explained, I will recommend this channel for excel tutorial to my friends.
Best, best , best dear, good Communication way, i appreciate you..
Yar aj apki video dekhi he Ap k samjhane ka andaaz bra dhansoo he Lo subscribe bhi kr diya Bell icon bhi press ker diya Now waiting for your next video Superbbbb bro !!!!
Good initiative, Keep it up, I am use many time, 👍👍👍👍👍👍
ahaaaa...bohat umda tareeqa pehli baar maza aa gaya samajh ker ... Excellent..love from Pak....
Way of teaching and explaining is sooo good even more interesting.
आपके समझाने का तरीका अच्छा लगा।। मुझे इससे मदत मिलेगी, धन्यवाद!!
Bohat hi khoobsurat andaaz hai samjhane ka. Awesome bro👌👌
Aap bohot hi lajawab ho sir Hats off to U 😇 Itna Aram se maine kisi ko nahi dekha samjhate hue Lv from Hyderabad ❤️
Best trick to teach. you are the best teacher. Best video for ever I watched for Vlookup.
Love you Rishab the way you are explaining in video’s it’s every clear and I Learn a lots. Thanku ❤️😊
Nice tone and clear dialog delivery along with superb attitudes
Very sweet voice you have and i like your frank interaction with us...Good job very sweet tutorial.
Thanks sir you are super talented superstar incredible lovely voice like voice artist , creative teacher ever with detailed explanation...a lot thanks
I have done this first time. you are the best of All. thanks a lot.
thank you sir,,,, super tutorial i forget vlookup formula and i searched so many video but finaly your video very helpful to me ,,, thank you once again
Wonderful teaching style and lecture. Covered all the necessary lessons to taught.
@ANOOPS70
6 жыл бұрын
kzread.info
Thanx a lot for teaching in such an interesting manner.....A novice like me too got it...
Wow Sir apke pdhane ka style bhutttt achcha hai I like it 😘😘😘😘😘
sikhane ka tarika 1 no., problem ke sath solution bhi..nice
Aap k samjhaney ka tareeka bohat simple or effective hai thanks
Fantastic Sir.=VLOOKUP(cell number of the reference,feels of the lookup cells + F4,the cell of the looked up item,0 or 1(0))
Amazing teaching methods THANK YOU
Very helpful, Also explained greatly what not to do, which can lead to error
Thank you, it helped me save a lot of time.
Bohot hi sahi tarike se smjhaya h sir ...👌👌
bhai voice quality bohot achchi hai uske sath samjhane k style bhi easy hai or sabse achchi baat samjhane k style bohot dostana hai na ki teacharana.
Way of spoken and enthusiasm level is attractive. 👌👌👌👌👌👌👌👌👌👌👌👌👌👌Great Sir
His way of teaching is excellent.....impressive
Superb Dost.. what a simple and amazing way you explained this... Kudos !!
@ExcelSuperstar
6 жыл бұрын
Thanks, Puneet Sharma Keep Watching our latest Tutorials
Thanks a lot for helping us with this knowledge... :)
The way of explanation is great 😘😗 Please help us with more more videos . Thank u sooooooo much 😘😘😗😗
Best se bhi best teacher 👏👏way of teaching is really amazing very good 👍
Sir aap bohot achhi tarah se samjate he. Thank u sir for teaching vlookup.
very intriguing..GOD BLESS YOU
GOOD DAY.. SIR YOU ARE BRILLIANT.... I HAVE LEARNED SO MUCH FROM YOUR VIDEOS. I AM ALSO AN I.T INSTRUCTOR IN AN INSTITUTE AND TRY MY BEST TO TEACH LIKE YOU. LOTS OF RESPECT & REGARDS FOR YOU.. REGARDS, NAVEED ALAM FROM KARACHIU, PAKISTAN
Thank you... You just saved my 2 days of work...😊
Thanks for uploading this video love you
Nice one. I was little bit confuse in vlookup but now all cleared.
Brother you're a superb teacher... Love and best wishes from Pakistan
अन्दाज। पसन्द आया दोस्त . बहुत ही अच्छा समझाने का तरीका।
You made it so simple to understand, thank you Sir ji..
Super vedios, your tricks really helping to improve performance
Thnx sir aap bahut achha smjhate ho aaj finally clear ho hi gya vlookup formula
Your way of teaching is awsome...👍 Aaj tak koi mujhe itne acche se samjha paya he , akhir me mene sikh he liya..😅🤣
You are Great!! I like the way you explained this.
Superb tutorial.. very easy way of teaching
Superb beautifully explained thanks a lot for helping ...🙏
You are amazing man - fun to watch and learn
wow aapke samjhane ka tarika bahut accha hai jyada se jyda first time me hi samjh aa gya
I have never seen the concept you teach , you are the best ever
Thank you so much Sir From MP, India. Very helpful tutorial. But I have some questions to ask you about, One of them is when will we use "IFERROR" before VLOOKUP???