Vlookup to Get Complete Record | Column , Columns | Lookup Full Record
Вставка
- Опубліковано 5 жов 2024
- In this video see how to use VLOOKUP to retrieve an entire record using traditional method and enhanced two methods:
1) VLOOKUP WITH COLUMN 2) VLOOKUP WITH COLUMNS
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#Vlookup #Vlookupwithcolumns #Innozant #Exceltutorial #ExcelVlookup
Bro, I have to admit, you are one of the best Excel teachers I've come across on UA-cam.
really means a lot to me
Well
Best Mentor in Excel, I have ever seen Sir. Love you Sir from Bangladesh.
Thanks for your valuable appreciation.. Really means a lot to me
First Time I am learning a real VLookup which I can use in Office work, No one teach me like this even I had done Advance Excel course from computer classes. Thank you so much Sir.
Thanks dear ..Keep learning
thanks
That's the actual vlookup concept I was looking for to get ride with lengthy process. Thank You so much Dilip Sir !!!
thanks dear
Sir you are great. Your way of teaching far better than other teachers
Thanks Ankit Ji for such a wonderful comment.. Really Means a lot to me dear .♥️🙏👍
sir, you teach very well, I like your teaching way, you explain every thing very well, I have watched your's lots of video related to excel and related to interview.
Thanks Divya..Have a wonderful career ahead ❤️.God bless You
Sir you are one of the best Excel teacher in UA-cam. Your videos really help me a lot. Thanks sir keep it up.
Thanks..Keep growing dear
Dear sir, I learn a lot from your video. It is amazing and simple to understand. With reference to the above video, I would like to tell the peoples who commented, that you can fetch value by inserting multiple column index number in curly bracket.
e.g. {2,3,4,5}
It is easy to do.
But sir, I learn a new concept of COLUMN and COLUMNS from you. Thank you so much for such kind of knowledge you are providing to peoples like me who always try to find their answer on you tube.
👌 👍 the way of interpretation excel is outstanding just say I don't have words to say thanks sir you enhance my skills and edge over the other professional .
Thanks Naveed .. Really means a lot to me..Keep learning..Keep exploring ❤️👍
Your style of teaching is so interesting and attractive.
Thank you very much for your effort. 🙏🙏
Very Clearly, Clear My All Doubt in Single View , Your are a Great Teacher ,
Thanks Sir 🙏
Thanks Suraj..Means A lot to me
Thanks for sharing your knowledge, your teaching will take us one level up to my skill , As I have tried the formula for single row is working but for multiple row the same value are displaying in below row column wise
You womt freeze columns or row value.kindly watch the video and apply the said concept..You may be doing minor mistake.
@@Innozant it doesn't work still if you post with multiple columns it helps
sir, your teaching skill is mind-blowing keep going sir.
Thanks Jamal.. Really means a lot to me dear🙏❤️
very helpful video, most of the persons facing the same issue, Thank you
Guru ji aapke Charan sparsh karne hai ..apke jesa guru mene kahi nahi dekha...apni whole life me khi bhi nhi...if aap delhi se hai toh please mai apse milna chahta hu sir..
Thanks Sharma Ji itne valuable appreciation ke liye,Life me bht aage jayen aap yahi wish hai.Haan jaroor milenge dear...Delhi se hi hain aap Innozant website visit kar sakte hain😊❤️👍
Very beautifully explained.
U have provided sheet also, that's also helping in understanding very clearly.
Thanku Soo much. Keep it up 👍
Thanks Jaishri for wonderful feedback.It really motivates me a lot.Soon Planing to launch Virtual Classroom Training for those candidates unable to came here and join the same.
One of the best Excel teachers i have ever seen….
Really means a lot to me ..God bless you .keep learning
Sir your teaching skill very nice clear all questions
Guruji... Aap ke sikhaane ka andaaz bahut achha hai ... It's our luck to have the guide like you... 🙂🙏
Thanks Hemendra Ji
MashaAllah, very nice teacher. Great respect from Pakistan.
Thanks dear
WOOW, What a teaching skills, Your the rear guru. Thank you sooo much.
Thanks Anand Ji.Keep Learning ❤️👍
Your excel knowledge next level sir 👍
❤️👍
Thanks a lot for explaining in such detail. I was confused with this.
Thanks Sandip ji🙏❤️
Best teacher in excel ever seen in yt
Thanks
Bahut bahut dhanyvad Sir aapka. Index match jise thoda tough lagta hai is ke liye ye best hai. 👌 🙏🙌👏🔥
Thanks dear
your teaching skill is mind-blowing
Thanks Tarak❤️
Aapka samjhane ka tarika ultimate hai.. ultimate
Thanks Deepankar..God bless You dear❤️❤️
May Allah give you hidayah and accept all your efforts and services ! ❤️❤️🔥🔥❤️❤️
Thanks Sajid sahab❤️🙏
Thanku sir, aaj mjhe coloum or columns clear huaa hue hain.
Dil se or Charan espar karke dhanbad
Thanks Manoj Ji..Hope ab bhulenge nahin aap❤️
I had been trying this formula for a long today i was able to do it coz of your video.. Thanks ❤
My pleasure 😊
I am also one of the 70% people, now I have come out of 70% people. Smart trick Thank you sharing valueable information.
Thanks Kalyan Ji
Sir aap bahot acche tarike se sab explain karte ho... Very happy to learn from you🙏
Thanks dear
Thank you very much , you made us to understand it so simply.
your way of teaching is very funny, impresive and easy to understand
Thanks Khan sahab..Happy learning❤️
Really, it is so amazing, today i have learnt new thing.
Thank you so much for detail knowledge. It is very useful.
Thanks dear.. Happy Learning .
Very nice , dil se samjate ho sir, hats off.
Thanks Dheeraj for such a lovelu appreciation..Really means a lot
THE BEST VIDEO ON VLOOKUP+COLUMN
Sir, easy to learn from ur all video really helpfull, now I feel confidence,
Thanks
Thanks so much sir.. you are really a practical guru!! 😊
Sir need a guidance.. can we use Vlookup by matching the column header rather than column number?
Means returning value where the column header is same.. it will be a real big help..
Thanks sir
Sir.your way of learning is very good👍
Thanks Sanoj ji..Happy learning
Clear है सर अब कसम खा कर बोलता हु की आगे से वो वाहयात अप्रोच युस नही करेंगे सिर्फ columns ही युस करेगे 🙏🙏🙏
Haha.. thanks Manish ji .Happy learning
Excellent. You reach very easily.
Sir, i struggled with this for 3 daya now. You made it veryy easy, wish i knew about this channel earlier. 😊new subscriber sir 🎉
Keep learning..Keep growing
Nicely explained....aap par bhagwan ji ki kripa bani rahe...!!!
Thank you..! Dilip Jee. Best 👌 way of explaining..!
Thanks Farid sahab
it was very interesting and easy to understand. What if the column numbers or title sequence are not similar in both excel sheets or workbooks
Amazing .....great job sir....keep doing such video
Thanks dear.God bless you
You are a greater teacher than ever🤩🤩🤩
Thanks dear
Sir I have one question ⁉️ if we have multiples columns and want values from few columns and might be possible that columns which we I'm looking for is not in a sequence means a, b,c,d to z etc i want value from column a,d,c,y,z then how i populate the value from the mentioned columns.
Sir, bahut achchha bataya he, thanks for details
Thank you sir I Was looking for this , finally my problem has been resolved
Good 👍
I like you, you are interesting and your teaching way is the best
Thanks Babar Ali Sahab.❤❤🙏🙏
viwes likes q ni aa rhe. itne ache tarike se clear kr diya sb kuch.
thank u sir
Ayenge..logon ke is channel ka importance thora late samajh aayega dear..Yahan Fancy video..Excel ka jaadoo video dekhne ki viewers ko adat hai time se jayega.😀.❤🙏
Thank you Sir, You are great teacher....
Really you are genious teacher of excel
Thanks Raghav❤️🙏
thank you so much sir your way of teaching is awesome
Thanks Arpit
Very good teaching technique.
Thanks dear
Great Professor, excellent and simple explanation...kind regard.
Thanks Asif Sahab..keep learning..keep exploring ❤️
Both ways explained well. My question if I can use match formula instead of column?
I used n got same results
Wow, bohot kuch sikhne milta hai sir aapse.
Thanks Tushar Ji..Happy learning ❤️
Super ♥️ sir, Columns function kaa used Kar k total columns v calculate Kar shaktai hai hum🙏
ये तो कमाल का विडियो हैं 👍
Thanks Anand Ji..Happy learning
Sir Promise you now I will never use like 2 3 4 now i will ever use as per teach you us , Please continue
Thanks dear❤️
Ek dam simple way teaching krete ho Sir
Thanks Sunny...Love you dear...bht mayne rakhta hai mere liye Aapke ye words...Maine aage bhi koshish krunga apke umeed par khara utar sakun.tc..gn
@@Innozant bahut bdi baat h hmre liye jaisa apka teaching style ek dm ground zero level easy to understand. Achha lgta h agr kuch nya sikhne mile or ek bar m smjh ajaye. Thank u sir and Gn
It was very helpful video sir nice and appreciate it 😮😊
You're amazing, sir.
Good Morning ❤️ Thanks Chitra
Thank you very much sirG
very good expert person
Lack of words sir to describe ur brilliance
Thanks dear❤️🙏
Sir aapke video gajab ke hain or result oriented hain ,kya aap ek video bana ke bata sakte hain ki start kaha se kare means 1st class to latest class kafi dikkat ho rahi hain please kar dijiye hum jaise logo ke liye
Very nice information sir
Sir bahut Acha padhaye aap asa karta hu etna Acha se you tub per koi nahi padhayega
Thanks Raj..Keep learning ❤️
Very well explained vlookup in multiple column
Thanks dear
Sir you are the best!!!
Bahut Jabardast Sir Mza agaya......
You are great sir
bahot he acha concept hai sir ji tusi great ho
Thanks dear
column is better than columns as we have to count the no of column in the case of columns than only we can pass the range but in case of column we just need to pick that particular column.
iske limitations se bhi ha yaha hume use btana padega ki dusre column se value uthana ha to hum do colomn select kr rhe ha.I think isse far better ha ki vlookup with match lgay to wo result kisi bhi colomn me ho uthake de dega hume 2 colomn 3 colomn select krne ki jrurat nhi
Nice explanation .thnks sir for such a wonderful concept
Bahut videos dekhi per samjh aapka fun dekh ke aaaya
Thank you so much for your valuable inputs
Thanks .keep learning
I have learnt a lot through your videos thanks a lot But sir question h - suppose column no. 10 h and huge data h jisme sequence wise data nhi nikalna that time how can we use columns formula
Nice Explanation
Very good concept
Thank you so much
This is the perfect method 👌🏻
Thanks Ikram.❤️
excellent expiations
Excellent sir
Thanks a lot😊
Thanks ❤️🔥
Great work
Very helpful
I think Great teaching in excel sir
Thanks Md Riyaj❤️❤️
Thanks a bunch for making this video
Thanks Tathagata..Happy Learning ❤️
Sir u are great teacher
Thanks dear
beautifully explained
Thanks Sameera❤️❤️👍
Wow sir ji kya explanation hai 😁 great 😃😸😃
Thanks Amrita for your valuable appreciation.Reallly means a lot to me
Outstanding training in excel and I really appreciate your dedication towards it...Thank you so much...
Thanks Ranjan ji for valuable appreciation..Keep learning 👍❤️