XLOOKUP Function in Excel - Malayalam Tutorial

മലയാളത്തിൽ ആദ്യമായി എക്സലിലെ എക്സ് ലുക്കപ്പ് ഫങ്ഷൻ.
XLOOKUP function in Excel is explained with 6 different examples in this video.
Microsoft Excel പഠിക്കാനും, Data Analysis Skill മെച്ചപ്പെടുത്താനും ആഗ്രഹിക്കുന്നവർക്ക് വേണ്ടി പൂർണമായും മലയാളത്തിൽ തയ്യാറാക്കിയ ഓൺലൈൻ കോഴ്സ്.
www.udemy.com/course/microsof...
#ExcelMalayalam #XLOOKUPMalayalam #XLOOKUP

[@supermanfiroz369]

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

[@XLnCADMalayalam]

That's an awesome compliment. Thank you :)

[@rafinalakath]

Very correct. Loved very much

[@abhiradh2004]

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

[@manissery1956]

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🥺🥺🙌🙌🙌🙌

[@younuselachola]

Your patience is amazing

[@XLnCADMalayalam]

😀👍

[@ambilyok9792]

The best video on xlookup

[@abduljaleel576]

Well detailed explanation I will try God bless

[@bhagawaldas3239]

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

[@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...

[@younuspk2815]

Way to go..!! 👏👏

[@999vsvs]

Very good. Thanks.

[@MuhammadRafi-hq6pl]

Excellent presentation. Thanks

[@XLnCADMalayalam]

My pleasure 😀

[@masthanriyadh]

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

[@jijojoy5230]

Your presentation is awesome

[@XLnCADMalayalam]

Glad you think so!

[@abhi9672]

Thank you ajay 👍

[@XLnCADMalayalam]

My pleasure Abhi mon :)

[@nidheeshcheruvakkodan2985]

thanku this is so helfull for me.

[@XLnCADMalayalam]

Glad to hear that

[@jithinpaul855]

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

[@XLnCADMalayalam]

thank you😀

[@haskerarangathil56]

Thank you 👏

[@XLnCADMalayalam]

😀👍

[@msivasankaran9803]

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

[@XLnCADMalayalam]

Glad you think so!

[@arundineshkotta345]

Thanks bro

[@gokul152]

Well Explained.

[@XLnCADMalayalam]

Thank you 😀✌️

[@praveenbabu149]

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

[@sreejithramakrishnan123]

good explanation.

[@XLnCADMalayalam]

Glad you liked it

[@abhiradh2004]

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

[@Sreejithponkunnam]

nice presentation and voice 😊

[@XLnCADMalayalam]

😀 Thank you

[@suhailn5809]

Very Nice presentation. Keep going

[@XLnCADMalayalam]

Thank you :)

[@jeevaskumar4587]

Very nice explain

[@XLnCADMalayalam]

Thanks and welcome

[@mirzadxb2103]

Sirinte class valare upayoga pradhaman👌

[@XLnCADMalayalam]

Thank you

[@rasheedayappalli39]

Nice class 👍👍👍

[@XLnCADMalayalam]

Glad you like it!

[@sunil19803]

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

[@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.

[@sreedharans4940]

Great

[@achenmathew]

Good job AJ

[@XLnCADMalayalam]

Thank you :)

[@sharafuthayyil7568]

outstanding

[@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 💖💖💖

[@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?

[@uvaisk5967]

Super

[@XLnCADMalayalam]

Thank you :)

[@ajitvarghese5161]

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

[@manissery1956]

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.

[@iqbalvk1674]

Nice

[@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)

[@apkpk8618]

Sir conditional formatting. Vedio upload cheyyamo

[@XLnCADMalayalam]

Sure

[@farzanamusthafa3145]

Google sheet tutorials koode chyyanm please

[@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 👍

[@jositgeorge2008]

🙏🏻🙏🏻👍🏻👍🏻💐💐

[@anoopkj8087]

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

[@true4tech95]

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

[@naseerahamed6098]

Sir, Vlookup or Xlookup best

[@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.

[@manissery1956]

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.

[@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)

[@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.

[@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.

[@nithinkuruvilla2954]

Xloook up function ente excel available alla. Update cheyano?

[@vidhya5128]

Same thanne vlookup ilum cheyyamallo..

[@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.

[@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.

[@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

[@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)

[@abdulahadkallooriyakath1180]

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

[@XLnCADMalayalam]

Great suggestion 👍

[@XLnCADMalayalam]

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

[@kurienillirickal7195]

xlookup better than index match or not?

[@XLnCADMalayalam]

Yes

[@shulamite358]

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

[@XLnCADMalayalam]

Get the latest version of Excel (Microsoft 365)

[@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

[@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.

[@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

[@riyastriyas9961]

Sir Enthinannu f4 press cheythathu ath manassilayilla

[@XLnCADMalayalam]

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

[@sunuvinu007]

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

[@XLnCADMalayalam]

Yes.

[@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)

[@shajikp6784]

Xlookup kittunnilla not displaying in my sysrom

[@XLnCADMalayalam]

Try Excel online.

[@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 തന്നെയല്ലേ?

[@aseebkh5173]

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

[@praveenprakash9102]

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

[@XLnCADMalayalam]

XLOOKUP is available only for the Office 365 subscribers.

[@praveenprakash9102]

@@XLnCADMalayalam i am using office 365

[@ajitvarghese5161]

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