XLOOKUP Function in Excel - Malayalam Tutorial

Подписаться 160 тыс.

Просмотров 44 тыс.

50% 1

മലയാളത്തിൽ ആദ്യമായി എക്സലിലെ എക്സ് ലുക്കപ്പ് ഫങ്ഷൻ.
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

Опубликовано:

18 фев 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 139

@supermanfiroz369 3 года назад

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

@XLnCADMalayalam 3 года назад

That's an awesome compliment. Thank you :)

@rafinalakath 3 года назад

Very correct. Loved very much

@abhiradh2004 2 года назад

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

@manissery1956 2 года назад

Correct

@muneermohammed9512 2 года назад

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 Месяц назад

😀👍

@younuspk2815 3 года назад

Way to go..!! 👏👏

@bhagawaldas3239 Год назад

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

@jasimnishan610 2 года назад

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

@masthanriyadh 2 года назад

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

@abduljaleel576 2 года назад

Well detailed explanation I will try God bless

@ambilyok9792 Год назад

The best video on xlookup

@praveenbabu149 2 года назад

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

@999vsvs 3 месяца назад

Very good. Thanks.

@abhiradh2004 2 года назад

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

@ajitvarghese5161 2 года назад

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

@jithinpaul855 2 года назад

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

@XLnCADMalayalam 2 года назад

thank you😀

@msivasankaran9803 3 года назад

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

@XLnCADMalayalam 3 года назад

Glad you think so!

@MuhammadRafi-hq6pl 2 года назад

Excellent presentation. Thanks

@XLnCADMalayalam 2 года назад

My pleasure 😀

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

@nidheeshcheruvakkodan2985 2 года назад

thanku this is so helfull for me.

@XLnCADMalayalam 2 года назад

Glad to hear that

@arundineshkotta345 4 года назад

Thanks bro

@mirzadxb2103 3 года назад

Sirinte class valare upayoga pradhaman👌

@XLnCADMalayalam 3 года назад

Thank you

@haskerarangathil56 Год назад

Thank you 👏

@XLnCADMalayalam Год назад

😀👍

@anoopkj8087 2 года назад

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

@sreejithramakrishnan123 7 месяцев назад

good explanation.

@XLnCADMalayalam 7 месяцев назад

Glad you liked it

@abhi9672 4 года назад

Thank you ajay 👍

@XLnCADMalayalam 4 года назад

My pleasure Abhi mon :)

@sunil19803 2 года назад

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

@XLnCADMalayalam 2 года назад

Thank you :)

@jijojoy5230 2 года назад

Your presentation is awesome

@XLnCADMalayalam 2 года назад

Glad you think so!

@gokul152 4 года назад

Well Explained.

@XLnCADMalayalam 4 года назад

Thank you 😀✌️

@10morrisonka 4 года назад

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

@XLnCADMalayalam 4 года назад

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

@10morrisonka 4 года назад

@@XLnCADMalayalam 💖💖💖

@Sreejithponkunnam Год назад

nice presentation and voice 😊

@XLnCADMalayalam Год назад

😀 Thank you

@rasheedayappalli39 3 года назад

Nice class 👍👍👍

@XLnCADMalayalam 3 года назад

Glad you like it!

@sreedharans4940 2 года назад

Great

@suhailn5809 2 года назад

Very Nice presentation. Keep going

@XLnCADMalayalam 2 года назад

Thank you :)

@sharafuthayyil7568 3 года назад

outstanding

@achenmathew 2 года назад

Good job AJ

@XLnCADMalayalam 2 года назад

Thank you :)

@jeevaskumar4587 4 года назад

Very nice explain

@XLnCADMalayalam 4 года назад

Thanks and welcome

@vidhya5128 3 года назад

Same thanne vlookup ilum cheyyamallo..

@sakkeerjahan 4 года назад

Good explanation

@XLnCADMalayalam 4 года назад

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

@farzanamusthafa3145 2 года назад

Google sheet tutorials koode chyyanm please

@true4tech95 3 месяца назад

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

@uvaisk5967 2 года назад

Super

@XLnCADMalayalam 2 года назад

Thank you :)

@nithinkuruvilla2954 2 года назад

Xloook up function ente excel available alla. Update cheyano?

@manissery1956 4 года назад

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

@XLnCADMalayalam 4 года назад

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.

@naseerahamed6098 2 года назад

Sir, Vlookup or Xlookup best

@apkpk8618 4 года назад

Sir conditional formatting. Vedio upload cheyyamo

@XLnCADMalayalam 4 года назад

Sure

@JithinRTrivandrum 3 года назад

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 3 года назад

Yes. XLOOKUP is available in VBA too

@JithinRTrivandrum 3 года назад

@@XLnCADMalayalam Thanks 👍

@iqbalvk1674 3 года назад

Nice

@XLnCADMalayalam 3 года назад

Thanks

@rasinahari176 3 года назад

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

@XLnCADMalayalam 3 года назад

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

@shabeere8754 3 года назад

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

@XLnCADMalayalam 3 года назад

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.

@vishnusoman8532 2 года назад

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

@XLnCADMalayalam 2 года назад

You are right. This is exactly why VLOOKUP and INDEX MATCH formulas are still useful. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q0XfqK_TXFA.html

@pradheeshkr999 2 года назад

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

@XLnCADMalayalam 2 года назад

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.

@sujithp6402 4 года назад

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

@XLnCADMalayalam 4 года назад

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 4 года назад

@@XLnCADMalayalam how did i get Office 365 Subscription.

@XLnCADMalayalam 4 года назад

@@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 3 года назад

Could you send this file.

@lineeshkumark9569 3 года назад

How to extract last one week cumulative sum in running total

@XLnCADMalayalam 3 года назад

SUMIFS function can handle conditions like these.

@shajicherian1892 3 года назад

A new info for me

@XLnCADMalayalam 3 года назад

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

@jerrybaij 2 года назад

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

@XLnCADMalayalam 2 года назад

I suggest contacting the Microsoft Support Team.

@aseebkh5173 6 месяцев назад

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

@jositgeorge2008 2 года назад

🙏🏻🙏🏻👍🏻👍🏻💐💐

@abdulahadkallooriyakath1180 4 года назад

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

@XLnCADMalayalam 4 года назад

Great suggestion 👍

@XLnCADMalayalam 4 года назад

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

@sibilnarimukkil5613 3 года назад

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.

@manissery1956 4 года назад

I do have office 365 subscription.

@XLnCADMalayalam 4 года назад

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

@joypoulose9080 3 года назад

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

@XLnCADMalayalam 3 года назад

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)

@shulamite358 11 месяцев назад

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

@XLnCADMalayalam 10 месяцев назад

Get the latest version of Excel (Microsoft 365)

@riyastriyas9961 3 года назад

Sir Enthinannu f4 press cheythathu ath manassilayilla

@XLnCADMalayalam 3 года назад

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

@apulse2apluskmkasim769 2 года назад

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

@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

@kassimkasi92 4 года назад

Ente lapil xlookup kittunnilla 16 version ann

@XLnCADMalayalam 4 года назад

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

@kurienillirickal7195 2 года назад

xlookup better than index match or not?

@XLnCADMalayalam 2 года назад

Yes

@sunuvinu007 2 года назад

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

@XLnCADMalayalam 2 года назад

Yes.

@sgpillai9943 3 года назад

Not working on my excel.why ?

@XLnCADMalayalam 2 года назад

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

@devu4240 2 года назад

Xlookup function excelil egana add cheyyuka sir

@XLnCADMalayalam 2 года назад

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

@devu4240 2 года назад

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

@muhammednaijun 4 года назад

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

@XLnCADMalayalam 4 года назад

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.

@shabeere8754 3 года назад

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

@XLnCADMalayalam 3 года назад

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