Vlookup to Get Complete Record | Column , Columns | Lookup Full Record 

That's the actual vlookup concept I was looking for to get ride with lengthy process. Thank You so much Dilip Sir !!!

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.

One of the best Excel teachers i have ever seen….

MashaAllah, very nice teacher. Great respect from Pakistan.

Sir, easy to learn from ur all video really helpfull, now I feel confidence,

Sir aap bahot acche tarike se sab explain karte ho... Very happy to learn from you🙏

Sir bahut Acha padhaye aap asa karta hu etna Acha se you tub per koi nahi padhayega

excellent expiations

Sir u are great teacher

Sir.your way of learning is very good👍

Thank you..! Dilip Jee. Best 👌 way of explaining..!

Hats off to you sir

THANKS FOR T HE VIDEO.

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.

Fantastic

Watching this video 2:31 Am from Delhi but - 3rd option Aacha laga 🤪🤪

Thanks Sir

Hello Sir, i need data like latest date sales number using vloopup like Column A Sales Name Second Column Date and third one is sale number now i want sale number latest date using vloopup up

Bro, I have to admit, you are one of the best Excel teachers I've come across on RU-vid.

Best Mentor in Excel, I have ever seen Sir. Love you Sir from Bangladesh.

What if the ID repeat more than one time how to get all the records? Please help

How to use vlookup one workbook/worksheet to another workbook with the help columns formula

Thank you very much sirG

How to make table array dynamic? Like I choose the file or file name and data is fetched. Let me know, please

Sir, if I have dump excelsheet but I want another excel sheet working some particular row and column, how to use vlookup formula from dump excelsheet.

Vertical karke dikhao dear. I am begginer. Me Excel seekh rha hu.ek hi formula se fix karke click and drage karna . Vo bhi samjha deejiye🎉🎉❤👍👍👌🙏🙏

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 please....vlook up with column achhe se ae bar bataiye...nahi ho Raha hain...parishan ho gaya hnu main... solution dhun dhun ke... Please thoda jaldi bataiye

sir, aap freeze kaisa kar rahe hai. what is the command you are using. Mere pass windows 2010 version hai. Aap kya use kar rahe hai.

You great

Sir Where can I get step by step videos of your Excel learning. Means I need not to come back to see the previous videos for advance learning.

Thanks ❤️🔥

Super ♥️ sir, Columns function kaa used Kar k total columns v calculate Kar shaktai hai hum🙏

Sir, एक problem है columns मे, अगर मेरा data range बहुत बड़ा हो और मुझे lookup value, kahi तीस या चालीसवें नंबर से शुरू करना हो, और column number बड़े data के कहीं बीच में से कुछ column तक का data pick करना हो तो, हम कैसे याद रखेंगे बड़े डाटा range मे columns number कहा से शुरू करना है, बड़े data range मे column number गिनना पड़ेगा, कृपया मार्गदर्शन करे please बहुत आभारी रहूँगा l धन्यवाद् 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

Abhi mano muje sirf LAST,EMAIL and PHONE data chaiye tab kese karenge

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

Sir, I have a data of 30-30 Minutes media show slots... and a leads coming every minute and second wise. how can i mapped dynamically media show slots wise... please help me....

Sir, what if the first row is empty, then how will we use the COLUMN formula to find col_index_num?

i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..

Hi i am trying from different work books. Thoda galat hora hai. Please help if you can connect????

can u pls explain same by using different work books...does it give same results???

when dataset not start from column index 1 and column name in different sequence.... in this scenario will it work?

SIR ONE PARTY THIS CONDITION CONCEPT GOOD,BUT MULTIPAL CONDITION NOT EFECTIVE.PLEASE SUGGEST

Bhai, if I need to fetch my record columns no. 8 so I have to select 8 columns. Am I right? Guju ji

अभिनंदन! पढाने की रीती बहो...........त! खूब! शास्त्रीय हैं. अभिनंदन! कर सकता तो 100 लाईक एक ही बार करता. धन्यवाद!

Sir ap mere😂ek quier or solve kar skte ho I am joining you channel to day 1st tym and u clear my all double in lump sum thanku so match i have a little bit dout Is that column ()-value se b ek baar ap mere concept clear kar skte ho 😅😅😅 please i request u

Require solutions when header of column B matches with header of column x, then insert only data

Indirectly it is to find 2.3.4 .. v+match is better choice over this...

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

sir i tried with same formula, it done, but for single row only. when we drag it, it only gives result for first row as it was freeze. kindly suggest what should we do if we have more than 2000 rows.

Seracheble drop-down list me multiple columns ka data kese laye? Es par video jaldi se banao

Guruji how if coulums not in sequence it's 3rd coloum or alternative columns then how it will make dynamic

It doesn't work on multiple sheet like you have table in one sheet and wanted to pickup data from another excel. It didn't work for all columns

But match function me hme ye dkhne ki jrurt nhi hoti ki konse column me h mera output data...yaha mujhe dkhna hoga column no. And then accordingly reference dena hoga

Sir, agr columns waly formula ko drag down krty hain to get values in other remaining rows, us mai ye sai apply nahi ho raha. How it can be done?

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.

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

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

Guru ji. M vlook colomn k 7 use kr rha hu to data 3rd colomn ki jagah 4th colomn ka data shown kr rha h...

sir ,ap ka process bahut hi sandar h maine try kiya or kam bhi kr rha h columns ka formula but sir ye kya only single person ka data deta hai. because sir mere pas aise 10 logo ka data h maine 1st wale pe apply kiya columns ka formula wo kam kr gya but jb mai ese niche drag down kr rha hu tb kam nhi rha ..

Sir Columns me array me puri table ko select krna nahi hota kya Your mobile dena concept clear krna h

Sir agar maan lijiye agar reference value column number 40 ya 60 ke beech mein ho toh kaise karenge

Sir agar isme last name and phone number chahiye hoga beach ki value nahi chahiye to vlookup kaise use karenge

Sir mere ko coloums ke bad mai jo freze kiya usse coloum kyu badta hai bina freze kiye kyu nahi badta

Mera1 sir question hai aapne Formula ko copy Kiya hai kya aaur Drak

👌 👍 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 .

bro isme Formula agar niche drag kare toh nai aara hai. Please help

Bahut videos dekhi per samjh aapka fun dekh ke aaaya

Hi.. This is good.. But when we use it in high volume data.. It takes a long time..

Bro agr hamen column "first" skip krna ho formula se to kia kren?

how to format change in table array by lookup value find ??

Sir you are great. Your way of teaching far better than other teachers

how to absent employees name highlight according to date in attendance sheet

But these methods not work when required columns not belongs in series

It was very helpful video sir nice and appreciate it 😮😊

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

Dear sir i need ur help.... I have a complex data file. Like school time table and i want to get teacher wise time table.

How can vlookup will work on column 1, column5, column 10 and so on at one time

Sir, bahut achchha bataya he, thanks for details

IN CASE AT TIME MORE THAN 1 ID KA VALUE SEARCH ARENGE TAB LOOK UP VALUE FREEZE KARKE ERROR ATA TAB KYA KARKENGE SIR

Column or columns sikhne ke baad row or rows bhi sikhchuka hu

Hero bhai

Best,but we need the middle of 3,5 in this case how to take out all columns

I am not able to apply in merge data sheet to sheet Vlookup

Sir fee slip bananay kay leya help chaheya ta please how i contact with you

May Allah give you hidayah and accept all your efforts and services ! ❤️❤️🔥🔥❤️❤️

Amazing .....great job sir....keep doing such video

Your excel knowledge next level sir 👍

Iferror vlookup and column will do it

Thank you so much for detail knowledge. It is very useful.

How to find row wise multiple value

Osum 👍

Sir, i struggled with this for 3 daya now. You made it veryy easy, wish i knew about this channel earlier. 😊new subscriber sir 🎉

Bahut Jabardast Sir Mza agaya......

Apne Sahi bola Vahiyat sab log use kar rahe honge.......jab tak apka video na dekh le tab tak......

this is only for single value search

Nahi aa raha he try kiya mene pls some one help

Thanks a lot for explaining in such detail. I was confused with this.

Hi dear brother. thanks for updated this video. actually all veiwers are would like to find out the solutions with in very shorty.your explanations is too long.so kindly try to explain with in short or some peoples will get irritate.

i am unable to use this can you please help