XLOOKUP Function in Excel - Malayalam Tutorial

[@supermanfiroz369]

ഇത്രയും ക്ഷമയോടെ കാര്യങ്ങൾ വിവരിക്കുന്ന ഒരു യുട്യുബറെ ഞാൻ കണ്ടിട്ടില്ല 😃

[@XLnCADMalayalam]

That's an awesome compliment. Thank you :)

[@AadaabStories]

Very correct. Loved very much

[@abhiradh2004]

സത്യം ശരിക്കും മനസിലാകുന്ന വീഡിയോ 😘😍

[@Hari-n4f]

Correct

[@muneermohammed9512]

Ente ponnashaaaneeee……excel njn oru tholvi aaayirunnuuu….sirinte channel regularaayi kandathin shesham ippo officil ente seniors n vare njn aaann excel paranju kodukkunnath!!!thanks annnaaa🥺🥺🙌🙌🙌🙌

[@manikandankrishnan9584]

Very good and patient teaching

[@XLnCADMalayalam]

😀👍

[@masthanriyadh]

ഞാൻ കണ്ടിട്ടുല്ലതില് വെച്ചു നല്ല വിശദീകരണം , പെട്ടെന്ന് മനസിലവുന്ന ക്ലാസ്

[@Sreejithponkunnam]

nice presentation and voice 😊

[@XLnCADMalayalam]

😀 Thank you

[@mirzadxb2103]

Sirinte class valare upayoga pradhaman👌

[@XLnCADMalayalam]

Thank you

[@younuselachola]

Your patience is amazing

[@XLnCADMalayalam]

😀👍

[@nidheeshcheruvakkodan2985]

thanku this is so helfull for me.

[@XLnCADMalayalam]

Glad to hear that

[@jithinpaul855]

You are simple....but powerful.❤🙏👍

[@XLnCADMalayalam]

thank you😀

[@abhiradh2004]

നന്ദി ബ്രോ ഇതുവരെ v look up ആയിരുന്നു ഉപയോഗിച്ചിരുന്നു അതിന്റെ കുറവുകൾ ഒക്കെ പരിഹരിച്ചത് അഡിഷണൽ ഫോർമുല ആഡ് ചെയ്താണ് 😓 ഇത് എന്തയാലും പൊളി 😍🙏

[@sreejithramakrishnan123]

good explanation.

[@XLnCADMalayalam]

Glad you liked it

[@ambilyok9792]

The best video on xlookup

[@haskerarangathil56]

Thank you 👏

[@XLnCADMalayalam]

😀👍

[@sunil19803]

വളരെ നല്ല അവതരണം.. 👍👍കാര്യങ്ങൾ വളരെ വെക്തമായി മനസിലാകുന്നു...🙏

[@XLnCADMalayalam]

Thank you :)

[@msivasankaran9803]

Your class is very Very useful for excel users. Thank you

[@XLnCADMalayalam]

Glad you think so!

[@jijojoy5230]

Your presentation is awesome

[@XLnCADMalayalam]

Glad you think so!

[@suhailn5809]

Very Nice presentation. Keep going

[@XLnCADMalayalam]

Thank you :)

[@sonymathews3142]

Super helpfull

[@XLnCADMalayalam]

Glad you think so! :)

[@10morrisonka]

Goooood moooorniiiinnggg!! MtNegroooo's here ! :-) Thank You, Sir !! Your Malayalam is just perfect !! 😍😍😍

[@XLnCADMalayalam]

You are welcome, Miss Montenegro. First as usual ✌️😇❤️

[@10morrisonka]

@@XLnCADMalayalam 💖💖💖

[@bhagawaldas3239]

Beautiful, easy to grasp and rhythmic explanation. So grateful for your kind imparting knowledge. Thank you very much ❤️

[@younuspk2815]

Way to go..!! 👏👏

[@MuhammadRafi-hq6pl]

Excellent presentation. Thanks

[@XLnCADMalayalam]

My pleasure 😀

[@abduljaleel576]

Well detailed explanation I will try God bless

[@jasimnishan610]

Ajai bai....Thanks for ur valuable informations and they way of conveying excel classes...I think ur classes is better than join in a computer private institutions...

[@rasheedayappalli39]

Nice class 👍👍👍

[@XLnCADMalayalam]

Glad you like it!

[@abhi9672]

Thank you ajay 👍

[@XLnCADMalayalam]

My pleasure Abhi mon :)

[@jeevaskumar4587]

Very nice explain

[@XLnCADMalayalam]

Thanks and welcome

[@999vsvs]

Very good. Thanks.

[@apkpk8618]

Sir conditional formatting. Vedio upload cheyyamo

[@XLnCADMalayalam]

Sure

[@uvaisk5967]

Super

[@XLnCADMalayalam]

Thank you :)

[@jobinjose5192]

beautifully explained. I joined ur udemy class but couldn't find Xlook up there. Is possible to download the excel file you r working?

[@gokul152]

Well Explained.

[@XLnCADMalayalam]

Thank you 😀✌️

[@praveenbabu149]

Your sound is almost ditto to the sound of an anchor in the Krishideepam program..

[@achenmathew]

Good job AJ

[@XLnCADMalayalam]

Thank you :)

[@sakkeerjahan]

Good explanation

[@XLnCADMalayalam]

Glad that you like it. I recommend you to check my video on the 6 new Dynamic Array functions in Excel.

[@arundineshkotta345]

Thanks bro

[@sharafuthayyil7568]

outstanding

[@farzanamusthafa3145]

Google sheet tutorials koode chyyanm please

[@iqbalvk1674]

Nice

[@XLnCADMalayalam]

Thanks

[@anoopkj8087]

Hello Sir, cell reference absolute ആക്കി മാറ്റുന്നത് കൊണ്ടുള്ള പ്രയോജനം എന്താണ്?

[@rasinahari176]

Dear sir, Ms office 2013 il xlookup function engane add cheyyaam ennoru video edamo

[@XLnCADMalayalam]

Right now, XLOOKUP is only available for Office 365 subscribers and Excel online (free)

[@Hari-n4f]

Much required function. It is not available for me right now. Thanks dear Mr Excel Guru

[@XLnCADMalayalam]

You are welcome :) Office 365 subscription is needed to use XLOOKUP, UNIQUE, SORT, SORTBY, RANDARRAY, SEQUENCE, FILTER, XMATCH and STOCKHISTORY functions. On 27 June, 2 more new functions called ARRAYTOTEXT and VALUETOTEXT were released to 50% of Office Insiders.

[@JithinRTrivandrum]

This is so amazing excel has merged vlookup , hlookup , Index , Match , Max , Min functions together in XLOOKUP, Do we have this functions available in VBA ?

[@XLnCADMalayalam]

Yes. XLOOKUP is available in VBA too

[@JithinRTrivandrum]

@@XLnCADMalayalam Thanks 👍

[@Sreejithponkunnam]

Multiple rows എങ്ങനെ റിട്ടേൺ ചെയ്യും . ഉദാഹരണത്തിന് BPL ലിസ്റ്റിൽ പെട്ട ഒന്നിലധികം ആളുകളുടെ rows എങ്ങനെ ചെയ്‌യും എന്ന് പറയാമോ in google sheet xlookup function (single row മാത്രമാണ് ഇപ്പോൾ റിട്ടേൺ ആകുന്നത് ) . Thanks in advance

[@XLnCADMalayalam]

Please check my video on the FILTER function.

[@Sreejithponkunnam]

@@XLnCADMalayalam thanks

[@shajicherian1892]

A new info for me

[@XLnCADMalayalam]

Wow! Then you should definitely check my video on 6 new functions in Excel. (Dynamic Array Formulas)

[@ajitvarghese5161]

Can you please advise how can we take 2 different values from one name... as vlookup gives u only one value..

[@joypoulose9080]

വളരെ നന്നായിട്ടുണ്ട്, പക്ഷേ Addin 64bit വേർഷൻ ഉപയോഗിച്ച് ചിലതെല്ലാം വർക്ക് ചെയ്യുന്നില്ല.ഫുൾ ആയി വർൿ ചെയ്യുന്ന ഏതെങ്കിലും Addin അല്ലെങ്കിൽ VBA വേർഷൻ ഉണ്ടോ?

[@XLnCADMalayalam]

XLOOKUP is not an Add in, but comes as a part of Office 365 subscription. XLOOKUP is also available in Excel for web (Excel online)

[@shabeere8754]

Hlo sir iam using 2010 version , and added xlookup 32 beta but sometime its not working properly plz give some......... rply

[@XLnCADMalayalam]

Please upgrade to the latest version of Excel (Office 365) to use XLOOKUP and 9 more new functions. Otherwise go for Excel online, which is free. I have done a video on this topic.

[@pradheeshkr999]

Sir,how can i install this XLOOKUP function in excel2019? Awaiting for your reply with step by step.

[@XLnCADMalayalam]

XLOOKUP won't available in Excel 2019. You need to purchase Office 365 subscription for the new Excel Functions like XLOOKUP, XMATCH etc., You can also try Excel online, which is free.

[@lineeshkumark9569]

How to extract last one week cumulative sum in running total

[@XLnCADMalayalam]

SUMIFS function can handle conditions like these.

[@sujithp6402]

I am using Microsoft Office Professional Plus 2019, I cannot find X LOOKUP function.

[@XLnCADMalayalam]

XLOOKUP, XMATCH and other new dynamic array functions are available only to the Office 365 subscribers. But you can try the web version of Excel which is free.

[@sujithp6402]

@@XLnCADMalayalam how did i get Office 365 Subscription.

[@XLnCADMalayalam]

@@sujithp6402 You should purchase the monthly or annual subscription from Microsoft. Either you can google for it or use the link shared in the description of the video.

[@renjithlr7228]

Could you send this file.

[@devu4240]

Xlookup function excelil egana add cheyyuka sir

[@XLnCADMalayalam]

The latest version of Excel (Excel Online, Excel with Microsoft 365 and Office 2021) have XLOOKUP, XMATCH and all latest functions.

[@devu4240]

@@XLnCADMalayalam sir njan oru video nokki add ins vazhi chaithu ..Excel option way add cheithu ..But equal kodukumbol angane oru function high light cheyyunnilla

[@jerrybaij]

Xlook is not giving me if not found option can you answer any possibility of error

[@XLnCADMalayalam]

I suggest contacting the Microsoft Support Team.

[@jositgeorge2008]

🙏🏻🙏🏻👍🏻👍🏻💐💐

[@vishnusoman8532]

Vlookupil ഉള്ള എല്ലാം Xlookupil work ആകുന്നില്ലല്ലോ Eg: curly ബ്രാക്കറ്റ്സിൽ നമുക്ക് ആവശ്യം ഉള്ള column number കൊടുക്കാൻ ഇതിൽ സാധിക്കുന്നില്ല

[@XLnCADMalayalam]

You are right. This is exactly why VLOOKUP and INDEX MATCH formulas are still useful. kzbin.info/www/bejne/p2G7l6SBlLmLfKM

[@true4tech95]

vlookup ,H LOOKUP XLOOKUP ELLAM erekure orepole allee use akunath sir

[@sibilnarimukkil5613]

Hi can i get the same sheet to practice?

[@XLnCADMalayalam]

60+ practice files are available with my online course on Excel. Please check the link shared in the description of the video.

[@kurienillirickal7195]

xlookup better than index match or not?

[@XLnCADMalayalam]

Yes

[@abdulahadkallooriyakath1180]

Error message എങ്ങനെ ഓവർ കം ചെയ്യാം എന്നുള്ള വീഡിയോ ചെയ്യാമോ . പലതരത്തിലുള്ള എറർ മെസേജ് എങ്ങനെ റിലേക്കേറ്റ് ചെയ്യാം എന്നുള്ളത്

[@XLnCADMalayalam]

Great suggestion 👍

[@XLnCADMalayalam]

Please check my blog post on different formula errors in Excel. xlncad.com/formula-errors-in-excel/

[@Hari-n4f]

I do have office 365 subscription.

[@XLnCADMalayalam]

Make sure that you have installed the updates. XLOOKUP is available to all O365 subscribers from 31 Jan 2020.

[@shulamite358]

Sir xlookup ia not shown in my excel..any solution?

[@XLnCADMalayalam]

Get the latest version of Excel (Microsoft 365)

[@bestinthomas2717]

enthina absolute reference aaki matunnath?

[@XLnCADMalayalam]

Check the following video kzbin.info/www/bejne/Z4fYqp2frJWrj6s

[@naseerahamed6098]

Sir, Vlookup or Xlookup best

[@sunuvinu007]

സർ, വി ലൂക്കപ്പിന് പകരമാണോ എക്സ് ലൂക്കപ്പ് ഉപയോഗിക്കുന്നത്?

[@XLnCADMalayalam]

Yes.

[@vidhya5128]

Same thanne vlookup ilum cheyyamallo..

[@nithinkuruvilla2954]

Xloook up function ente excel available alla. Update cheyano?

[@riyastriyas9961]

Sir Enthinannu f4 press cheythathu ath manassilayilla

[@XLnCADMalayalam]

Please watch my video on Absolute, Mixed and Relative references.

[@muhammednaijun]

Sir which version of ms office supports X look up function?

[@XLnCADMalayalam]

Right now, XLOOKUP function and all other Dynamic Array functions (SORT, SORTBY, FILTER, SEQUENCE, RANDARRAY and UNIQUE) are available only for the Office 365 subscribers.

[@sgpillai9943]

Not working on my excel.why ?

[@XLnCADMalayalam]

XLOOKUP is a part of Microsoft 365, Office 2021 and Excel online.

[@kassimkasi92]

Ente lapil xlookup kittunnilla 16 version ann

[@XLnCADMalayalam]

XLOOKUP and other 7 New functions are available only to the Office 365 subscribers.

[@praveenkurup6993]

How to download XLOOKUP??

[@XLnCADMalayalam]

XLOOKUP is available with the following versions of Excel. 1. Excel with Microsoft 365 2. Excel 2021 3. Excel online (Excel for web)

[@shabeere8754]

എന്റെ Excel 2010 ആണ് എനിക്ക് 2019 ഫ്രീ ആയി download ചെയ്യാൻ പറ്റുമോ, എങ്കിൽ അതിന്റെ വീഡിയോ ഒന്ന് ചെയ്യാമോ (മലയാളം പറഞ്ഞു കൊണ്ട് ചെയ്യാമോ )

[@XLnCADMalayalam]

Microsoft offers the web version of Office 365 for free and that too with limited features. Apart from that nothing is free.

[@apulse2apluskmkasim769]

ഇത് പഴയ Look up function തന്നെയല്ലേ?

[@shajikp6784]

Xlookup kittunnilla not displaying in my sysrom

[@XLnCADMalayalam]

Try Excel online.

[@aseebkh5173]

Xlookup function എന്റെ എക്സലിൽ ലഭിക്കുന്നില്ല

[@praveenprakash9102]

എനിക്ക് xloockup കിട്ടുന്നില്ല plzz help

[@XLnCADMalayalam]

XLOOKUP is available only for the Office 365 subscribers.

[@praveenprakash9102]

@@XLnCADMalayalam i am using office 365

[@sreedharans4940]

Great

[@ajitvarghese5161]

Can you please advise how can we take 2 different values from one name... as vlookup gives u only one value..