How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel

[@Meditation5235]

Excellent!!! Thanks a lot sohanji for sharing such innovative information. Please make a series of Excel Dashboard from Basic to Advance level. Thanks!!!

[@GyanOnTube]

Thanks we will do that..thanks for ur suggestion.

[@sandheliya]

बहुत ही साधारण तरीके से असाधारण जानकारी दी

[@GyanOnTube]

Thank you so much..

[@meghatrivedi9448]

Your Best Teacher I Like This Video

[@GyanOnTube]

Thank you so much Megha, keep supporting and keep sharing...do share this video with your friends and family

[@fearfreestudy35]

Bhot accha bataya hai.

[@GyanOnTube]

Bahut bahut sukriya aapka saurav ji..keep sharing keep learning

[@hashimbagwan1218]

Supperb hai sir thank you for sharing information

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@vkssrk]

Awesome formula, sab formulo ka baap hai .👍🏻👍🏻

[@GyanOnTube]

Very true..one of the best function in Microsoft..

[@GlacierGaur]

How simply you just taught this..Perfect !

[@GyanOnTube]

Thank you so much..😊

[@sumitgarg2601]

Bhai kya baat hai... Mera bhai excel guru ban gya. Wonderful!!!!

[@GyanOnTube]

Thank you so much 🙏🙏

[@sumitgarg2601]

@@GyanOnTube pachana kon?

[@GyanOnTube]

Not sure..

[@jaffersharrief884]

Amazing sir, Thank you very much for the details explanation.

[@GyanOnTube]

Thank you jaffer, do not forget to share this video..

[@sagarvyas5259]

Powerful formula explained in a simplest manner. Very informative, Sohan.

[@GyanOnTube]

Thank you so much 🙏

[@arvind_singh_vlog]

Kafi time se intzar tha aise formule ka

[@GyanOnTube]

Ji ha Arvind ji aur bhi bahut se Formule aa chuke hai..mere channel mein unsabki video hai aap sazoor dekhiye..

[@amiyacharansahu9062]

Good one 👍🏾

[@GyanOnTube]

Thank you so much

[@harishrathour7003]

Thanks sir new information dene ke liye sir or example de Xlookup ke

[@GyanOnTube]

Harish rathour ji.. aapke comment ke liye sukriya..aur bhi bahut se videos milegi aapko mere channel mein.. please share zaroor karna need ur support..

[@hareshparkara522]

Very good explanation

[@theescanor8985]

Bhai 1st of all thnk u so much... K apne practice sheet di... I downloaded that... N was really time saving... ❤❤

[@GyanOnTube]

Thank you so much 🥰

[@ektatrivedi3529]

Thanx very easy explain xlookup very useful vedio sir👍

[@GyanOnTube]

Thank you Ekta..

[@bindaas0406]

Thanks for sharing

[@GyanOnTube]

Thank you so much

[@MithunSapui]

Awesome Sir

[@GyanOnTube]

Thank you so much

[@ksrazmi281]

Sukriya sir

[@GyanOnTube]

Thank you

[@videosshorts6297]

You talking style amazing & impressive😊 & this is new imformation👍🏻

[@GyanOnTube]

Thank you so much... really appreciate your comment

[@videosshorts6297]

@@GyanOnTube you deserv it☺

[@asmrindia]

NICE

[@GyanOnTube]

Thank you Amit Kumar Sharma ji..keep sharing keep learning

[@abhishekdivedi1940]

Good job

[@GyanOnTube]

Thank you Abhishek divedi ji..keep sharing keep supporting

[@maneeshyadavyadav4711]

Thank you so mach sir

[@GyanOnTube]

Thank you Maneesh gor your comment..keep sharing keep supporting

[@riturautela7331]

Superb 👍👍

[@kishoresn6433]

splendid!!!

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@balasahebkhatke3966]

great

[@GyanOnTube]

Thanks Balasah khatke ji..

[@simfinso858]

बढिया है भाई.

[@GyanOnTube]

Bahut bahut sukriya.. please share with your friends and family.. keep supporting and keep sharing

[@prarora333]

Nicely n efficiently explained, thanks.

[@GyanOnTube]

Thank for your comment dev...do not forget to share this video

[@777you7tube]

Thanks for your time you spent making this video. I have two request. First one, Is there any way to use asterisk (*) like we do in Vlookup? Second request, can you please share the advanced dashboard with sensitive and future KPIs?

[@GyanOnTube]

Thank you for your comment... answer to your first question , yes we have options to use (*) with XLOOKUP.. secondly wi will prepare advanced dashboard with KPIs as well

[@777you7tube]

@@GyanOnTube thanks for your prompt response. Could you please share the video link, where we can find the second part of the name with an asterisk. For example, searching for a name: Krish if we only remember: ish.

[@kamleshsah6507]

Nicely explain Thanks

[@GyanOnTube]

Thanks Kamlesh

[@new_creativevideo]

Thanks sir

[@GyanOnTube]

Thank you gautam

[@meenumishra3106]

Really like your vedio😊

[@GyanOnTube]

Thank you so much

[@mrinalkantikansari4171]

Excellent !!!!!!

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@maithilnitesh]

Thank you so much sir From bottom of my heart❤ for making such an amazing vedeo. I hope it will help to all excel lover. Keep making such kind of videos.

[@GyanOnTube]

Nitesh mishra ji turly appreciate your comments..i have uploaded more videos please check i am sure u will like it and keep sharing the videos with those who want to learn excel...your support required

[@maithilnitesh]

@@GyanOnTube Absolutely Sir Since I have started to watch your vedeos I have to learn many more,also I have downloaded questions paper from your interview series and doing practices them.

[@GyanOnTube]

@@maithilnitesh thanks a lot.. greatly appreciate your support and keep sharing the video.

[@onlyexcel493]

You explain very well...

[@GyanOnTube]

Thanks

[@rabin3333]

Really good sir

[@GyanOnTube]

Thanks Robin

[@sameergawade15]

Excellent Excellent Excellent Good Job !!!!!!!

[@GyanOnTube]

Samir Gawade :- you can check more videos in my channel..i am sure you will like it and stay tune for more videos..

[@sameergawade15]

xlookup is working in Microsoft Excel 7?

[@GyanOnTube]

@@sameergawade15 nhi abhi its not available in office 2007..soon Microsoft will rollout this xlookup formula..i will suggest u to plz upgrade ur office version.

[@sameergawade15]

Okay thank you

[@video_banani_nahi_aati]

Sari jankari easily aur bina bakchodi k de di. 👍👍👍

[@GyanOnTube]

Thanks Shishpal

[@AftabAhmed-uw4ki]

Plz data entry ky upper full video bnao plz plz.🙏🏻

[@GyanOnTube]

Sure , will do soon

[@arvind_singh_vlog]

Good

[@GyanOnTube]

Sukriya Arvind ji..aur bhi bahut videos laaya hu new Formulas ke sath aap zaroor check karna.

[@arvind_singh_vlog]

@@GyanOnTube sure sir.

[@umeshaswani9950]

Wonderful

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@AliKhan65650]

Great

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@santoshtripathy7329]

Thanks man, it was an excellent piece of video.

[@GyanOnTube]

Santosh Tripathy ji really appreciate your valuable comment..i have uploaded many more videos please watch and share i am sure you will like it...need your support..

[@XCELTRICKS]

Kya baat hai...accha explain Kiya hai . ..I also making a video on it.

[@GyanOnTube]

Thank you

[@mushtaqali267]

bhaut acha explain keya welldone, bhai ye xlookup may apnay pc may installed Excel 2019 may kaisay use karun office insider ka option nahe show ho raha pleae help me to solve said problem. may bhee xlookup use karna chata hun

[@GyanOnTube]

Abhi xlookup official launch nhi kiya hai...isliye ye sirf office insider 2019 mein hi milega..aur aapko agar use karna hai to Microsoft ki site mein jaake office insider purchase kar lo..then you can use XLOOKUP

[@KrishnaKumar-xo2mi]

Super Bro pls update More intresting videos

[@GyanOnTube]

Thank you Krishna Kumar ji, i have uploaded many videos you can check in my channel.

[@sahilraja9931]

Amazing dost

[@GyanOnTube]

Thanks Sahil

[@pradeepkumar-il1xu]

Excilent

[@GyanOnTube]

Thank you so much

[@vimaldewangan9309]

Sir please make video & practice excel sheet for dependent drop down with multiply work with xlookup or vlookup

[@GyanOnTube]

Ye video already published kiya hai mene..aap mere channel mein dekh salte hai

[@vimaldewangan9309]

@@GyanOnTube Sir ye video maine bahut dhundha magar mujhe mila nahi

[@sknbbx]

Nice explanation sir... Thanks for the video

[@GyanOnTube]

Sanizz we have more videos uploaded...must watch and share..thank for your support..

[@dsraghav2882]

Super Sir

[@GyanOnTube]

Dharmendra singh raghav ji bahut bahut sukriya..ye video aapne friend and family ke sath share zaroor karna...

[@777you7tube]

Very nice video, bro.Thank you for sharing. However, I have a query on this I hope you can help me solve it. When I use the specific column to find (lookup array) from then the formula works but if use the whole range (or more than one column) it doesn't work. Is there any reason?

[@GyanOnTube]

Need to check the data for it

[@777you7tube]

@@GyanOnTube can i pls have your email id to send you the data? thank you

[@LalitKumar-pg2mo]

Thanks sir..

[@GyanOnTube]

Your welcome

[@onlyexcel493]

Good morning my dearest sir

[@GyanOnTube]

GM Nileshgiri

[@iamsainipawan]

Sir ms word par BHI video tutorial banaye please 🙏🙏🙏🙏

[@GyanOnTube]

Surw usme bhi lata gu video bahut jald

[@onlinetutionacademy6019]

great work dear!

[@GyanOnTube]

Thank you online tution academy ji..aap is video ko aapne friends ke sath share zaroor karna aur mein esii hi video lata rahunga aap logo ke liye..thank you for your support..

[@Pixindesign]

Accha laga

[@GyanOnTube]

Bahut bahut shukriya 🙏

[@Pixindesign]

@@GyanOnTube sir, pls ek video Stdiv function par banaye

[@GyanOnTube]

@@Pixindesign sure , thank you for suggesting..will prepare on this very soon

[@ajitmalankar8636]

Thanks bro

[@GyanOnTube]

My pleasure

[@ajitmalankar8636]

@@GyanOnTube vba macro pr koi series nikalo

[@GyanOnTube]

Sure bahut jald aane wali hai

[@krishgaming3570]

xlookup bahothi mast hai but sabhi officeces me chalna chahiye

[@GyanOnTube]

Abhi ye sirf office 365 insider mein hai..bahut jald ye 2019 and above me roll out ho jaega

[@vinodkapoor471]

Hello, Your video with example it's good but you should explain in slow motion instead of this video

[@GyanOnTube]

I agree...if i would have explained in slow this this video would have gone over 10 mis..just to save time i have explained in fast..if you want in depth about xlookup you can see my another xlookup video in detail. kzbin.info/www/bejne/b6XNiYmOpJuri9k

[@onlyexcel493]

Sir please index or match ki series banaiye

[@GyanOnTube]

Sure will work on it

[@sourabhsingha5628]

on example 3 result is showing as -100% instead of 82%, I am working on your attached sheet. Kindly guide sir.

[@GyanOnTube]

Are you applying the same condition or you are changing the value

[@AjayKumar-ey4ln]

Sir vba macro ki bhi vedio banaiye na

[@GyanOnTube]

Sure

[@ublogs]

i have a question. there are two tables (created with ctrl + t command) on the same sheet in first table there are two headings 1. subject 2. marking type (means particular subject will be awarded grades or marks) (for example there are four subjects i.e. ENGLISH , MATH, DRAWING, SPORTS, MUSIC) [FIRST TWO SUBJECTS WILL BE AWARDED MARKS AND REST OF THREE WILL BE GRADED] now there is second table having one column 1. grading subject aim of creating second table is to show only grading subjects from ist table WHICH ARE DRAWING SPORTS AND MUSIC XLOOKUP NOT WORKING IS THERE ANY OTHER OPTION?

[@GyanOnTube]

Unable to understand..need to check the sheet

[@ls-id8qc]

Last eg maih agar 2 last Rajverr ki value chahiye toh Kya karenge

[@GyanOnTube]

Very nice question IS ..aap nice wala video dekh sakte hai jisse aap value populate karwa sakte hai.. kzbin.info/www/bejne/Z3PGlntrqLyNe9E

[@ls-id8qc]

@@GyanOnTube tks Pls give your mail I'd i want to ask a tricky Excel problem

[@GyanOnTube]

@@ls-id8qc you can join my telegram group and ask as many questions there. @Excelinhindi

[@ismailhossain5663]

Boss make your videos little bit slow thanks.

[@GyanOnTube]

Ismail Hossain ji this was the only video which i make fast due to more information can be share in less time... however you can check my rest of the videos those are normal.

[@naveencore4608]

vlookup ka formula laga ke ctrl R press kijiye ho jayega ush ke sth agr neeche wale bhi chahiye to ho jayega ush ke liye ctrl D kuch jyda fyda nhii h

[@GyanOnTube]

Naveen VLOOKUP right to left chal sakta hai..nhi na..vlookup ek saat saare column ke data de sakta hai..nhi na..

[@GyanOnTube]

Aur bhi bahut faede hai...

[@dsingh8321]

Wild card b batayein sir

[@GyanOnTube]

Ek do din mein pura ka pura xlookup leke aata hu a to z...

[@GyanOnTube]

Xlookup mein wildcard ki video bana di hai..aap jaake dekh lo...D singh ji...

[@isararansari455]

How to use on another sheet in same file

[@GyanOnTube]

Isarar Ansari ji you can use in the same way, you just need to select the second tab while applying XLOOKUP.

[@JyotiMishra-fm5ix]

How to segregate sellers performance in different FYs say I. Your video Ashish's performance in 2017, 18 and 19

[@GyanOnTube]

Value paste and do text to column

[@nileshborate4312]

Hello bro, I am using 2019 version but I unable to get xlookup formula please advise

[@GyanOnTube]

Hi Nilesh ji..as of now XLOOKUP is o ly available in office 365...we need to wait for couple of more month..then we might get an update in 2019 as well for XLOOKUP..

[@anishsharma7858]

thoda dheere dheer smjayga toh better smj aayga.

[@GyanOnTube]

Agar dheere dheere samjata to video bahut long ho jaati..vese mene aapka point note kar liya.. thanks for ur comment..

[@anishsharma7858]

@@GyanOnTube video long matter nhi kerta, jisko smjna hai wo pura video jrur dekhega but smj aayga tb, i try to understand much but video has been so fast.

[@GyanOnTube]

@Anish Sharma point noted.. however you can watch my more videos i am sure you will be able to understand more... kzbin.info/www/bejne/pH_Wo2x7d5mVZ9k

[@alifirdous576]

How I can convert complete Excel sheet in round numbers?

[@GyanOnTube]

For that i have published a video. please check that

[@alifirdous576]

@GyanOnTube please share link

[@abhijitrkm]

Please provide vba for converting numeric value to word in rupees format for 14 digit number. This is necessary for estimating purpose. I am having upto approx Rs. Two hundred and fifty five crore only. If you capable then please provide. Thanking you in advance.

[@GyanOnTube]

Thank you so much for your valuable comment..i will definitely prepare a video on this soon

[@guptadk02]

How to install this xlookup in excel of MS office Home and Student 2016.

[@GyanOnTube]

I have already prepared a video on this...below is the link kzbin.info/www/bejne/bmKai2uLZ6aFe9k

[@sarfrazahmad2223]

How to install ms office 365 sir....

[@GyanOnTube]

You can go to Microsoft site and download that.. however that is a paid application now..

[@sarfrazahmad2223]

Please guide me to installation of ms office 365 process

[@sdtspv-ruhulaminkhan5211]

How can I get the "XLOOKUP"?

[@GyanOnTube]

Hi SDT, you need to wait for one more or so...as of now Microsoft just launch in office 365 ..soon it will be rollout to office 2019..

[@firdousahmad194]

office 2019 m xlookup nhi dikh rha hai

[@GyanOnTube]

Abhi XLOOKUP sirf office 365 insider program mein available hai..but bahut jald ye sab Excel mein rollout ho jaega.

[@RohitPatel-ip8wh]

Microsoft 2007 me kaam nahi kar raha hai

[@GyanOnTube]

Rohiy ji agar aapko saare new formule use karna hai yo aapko abhi ke liye office 365 install karna hoga jo bilkul free of cost hai.. kzbin.info/www/bejne/foGscqBug9-rfq8

[@RohitPatel-ip8wh]

@@GyanOnTube Sir download kese karna hai

[@GyanOnTube]

@@RohitPatel-ip8wh aapko last mein ek link milega jiske through aap free mein download kar sakte hai..

[@arnavaj3392]

Itna fast agar formula xplain krte to jyada easy hota understand krna .kya h return array ? Ye video sirf Apne liye Bnai h sayad kyuki viewers ko smjhne k liye thoda time dena pdta.

[@GyanOnTube]

Hi Arnav, mene pura formula hi explain kiya hai..aapko kya samaj nhi aaya ye bataoo plzzz..aur ye video mein sirf viewers ke liye hi banata hu...taki aage jaake wo isko use ksr paee..

[@markroy2374]

Bhai, itna jenjet kia jarui .... aek simle sa app nikalo na.... v,h,x,look up Bla bla bla.....

[@GyanOnTube]

Isliye to ab XLOOKUP nikala hai..one formula 10 solutions

[@isararansari455]

Not to getting proper result Pl make video

[@GyanOnTube]

Sure i will prepare a video on this soon..thanks for your suggestion

[@bishtlokesh1297]

I don't use of vlookup only xlookup

[@GyanOnTube]

Great Lokesh it is one of thr best formula which Microsoft launched till date.

[@bishtlokesh1297]

Yes

[@GauravSharma-zx6ih]

*OFFSET function sabka baap hai*

[@GyanOnTube]

Gaurav try karke dekhna xlookup kya kya kar sakta hai..jab use karoge pata lag jaega aapko...kaun kiska baap hai..

[@GauravSharma-zx6ih]

@@GyanOnTube lol, I think you have never used OFFSET function, jaha saare function fail ho jaate hai waha OFFSET hi kaam aata hai, relative macro ki coding aur VBA me OFFSET hi kaam aata hai.. Lookup, vlookup, hlookup, xlookup, I direct, Index functions sab bacchay hai OFFSET ke

[@GyanOnTube]

Thank you

[@pm143manish]

kuch nahi samja...

[@GyanOnTube]

Aapke pass XLOOKUP hai

[@mdahad-me9vs]

thanks sir

[@GyanOnTube]

Thank you so much