No video :(

VLOOKUP in Excel - Malayalam Tutorial

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

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

50% 1

ലോകത്തിൽ ഏറ്റവും കൂടുതലായി ഉപയോഗിക്കപ്പെടുന്ന മൂന്ന് എക്സൽ ഫങ്ഷനുകളിൽ ഒന്നാണ് വിലുക്കപ്പ് ഫങ്ഷൻ. എക്സലിലെ വിലുക്കപ്പ് ഫങ്ഷന്റെ സാധ്യതകളെ കുറിച്ച് വിശദീകരിക്കുന്ന വീഡിയോ.
How to use the VLOOKUP function in Excel is explained with 3 different examples.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/...
Subscribe to the channel ‪@AjayAnandXLnCAD‬ for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/...
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇത് വരെ ഉപയോഗിച്ചിട്ടില്ലാത്തവർക്കും, പഠിച്ചു തുടങ്ങാൻ ആഗ്രഹിക്കുന്നവർക്കും വേണ്ടി . . .
• Microsoft Excel Tutori...
#ExcelMalayalam #VlookupMalayalam #VLookup

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

5 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

what a brilliant voice modulation. Awesome and neat presentation. You did it crisp and clear. This is the exact pace someone need to do the presentation on learning new stuff

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

Wow, thank you!

@rameezmuhammed9356 Год назад

@@XLnCADMalayalam from where do i get the work sheet

@Dvl-md9dm 3 года назад

നിങ്ങൾ പൊളിച്ചു.... Ethrem simple aaytt no one can teach..... Great wrk sir and also thank u so much

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

😀🙏Thank you

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

എക്സാമ്പിൾ ആണ് നന്നായതു.. അല്ലെൻകിൽ ചിലപ്പോൾ മനസിലാകില്ലാരുന്ന്.. താങ്ക്സ്

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

Usefull , Instead of fee, I watched your vedios without skipping Ads

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

That's so kind, but you don't need to watch the ads to support me. You can skip it as it doesn't matter. Moreover, you can join my 'Microsoft Excel course in Malayalam' for structured learning. Check the description or comments section of the video for more details.

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

@@XLnCADMalayalam ok let me

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

നിങ്ങളൊരു ഭായി ആണ് ഭായ്. അടിപൊളി

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

explaining in a very simple and systematic manner!! good job, all the best!

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

Glad it was helpful!

@anoopthejus Год назад

Kidu

@XLnCADMalayalam Год назад

Thank you :)

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

Start learning Microsoft Excel in Malayalam ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TvefCbe9s30.html

@jinuperangattuvlogs Год назад

Good👍🏻

@XLnCADMalayalam Год назад

😀👍

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

It's very useful knowledge to all excel users, simply explained.. Thanks a lot...

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

My pleasure 😊

@vidhyasuji751 Год назад

very good class

@XLnCADMalayalam Год назад

Thank you😀

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

You examined well God bless

@jithinvj5467 Год назад

Superb… informative… thanx…. 👌👌👏👏👏👏

@XLnCADMalayalam Год назад

Most welcome 😊

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

Thankyu sir

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

My pleasure😀

@afeafeefa143 Год назад

Great class👍👍..very helpfull

@mrskull9103 8 месяцев назад

Very useful video, thank you..👍

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

Glad it was helpful!

@vishnuu2330 Год назад

Thanks, It's really helped me to lean this function.

@XLnCADMalayalam Год назад

😀👍

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

Thank You very much, It is very clear.

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

Glad it helped!

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

Simple and clearly explained..thank you😊

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

My pleasure.

@athulyanag7046 5 месяцев назад

Thanku

@XLnCADMalayalam 4 месяца назад

😀👍

@majjubm223 Год назад

Well explained. you videos are awesome. Thanks

@XLnCADMalayalam Год назад

Glad you like them :)

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

Thank you sir

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

My pleasure :)

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

Thanks വളരെ നല്ല explanation.

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

Glad to hear that. and thank you for posting feedback.

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

Very good explanation simple and useful 👍🏻👍🏻👍🏻

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

thank you sir. great effort.

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

You are welcome 😀

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

Your great sir, simple presentation Thanks very much sir

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

My pleasure 😀

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

Very useful VLOOKUP formula vedios that you Sir

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

Thanks and welcome

@adarshvgopal457 Год назад

Very much helpful and informative, Liked the way of teaching is simply awesome... keep going 🙌

@XLnCADMalayalam Год назад

Glad to hear that 😀

@nithinthehr1615 Год назад

Awesome, this was super helpful.

@XLnCADMalayalam Год назад

Glad to hear that :)

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

Thank you so much

@mylife-uncut105 4 года назад

Adipoli

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

Mikacha avatharanam👍

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

Thanks

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

Welcome

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

Very useful videos.. Pls keep doing it

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

Thank you :)

@dasanmyran Год назад

Great work simply awesome 👌👌

@XLnCADMalayalam Год назад

😀👍Thank you

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

Good. Very informative

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

Glad you liked it

@hashimrahmanofficial Месяц назад

Can u explain how vlook up using for copying datas from other files..

@XLnCADMalayalam Месяц назад

I hope the following video will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KxEl6toh0qE.html

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

Very useful video

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

Glad you think so! :)

@jahfarmk758 Год назад

Thanks u sir, superb class 👍

@XLnCADMalayalam Год назад

My pleasure :)

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

ഗുഡ്

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

Excellent presentation

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

Glad you liked it

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

Thanks.it helped alot

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

You're welcome!😀

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

Super class. Thank you

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

You are welcome

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

Super

@maheshappukuttanpillai7658 Год назад

Great

@XLnCADMalayalam Год назад

😀👍

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

Superb class....👍

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

Thank you :)

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

Useful Tutorial.

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

Glad to hear that

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

Nice

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

clear explanation ❤️

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

Glad it was helpful!

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

Very useful video sir

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

Glad to hear that and Thanks.

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

Thank you so much sir. This session was useful for me.

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

My pleasure :)

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

Thankssssss

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

My pleasure :)

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

THANKS A ALOT SIR,I have useful these vedio

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

You are welcome

@gokul152 5 лет назад

Good Explanations

@XLnCADMalayalam 5 лет назад

Thank you ☺️

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

I have seen a lot of explanation about V look up in youtube channel ,but the best one Mr. Ajay sir XL n CAD , easy to understand ,no boring at all .. could you please upload new video for us how to do Inventory control in excel ?if you did before please send me link Thank you so much Sir

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

Thank you for that awesome compliment. Regarding the video, right now I am concentrating on the different tools in Excel. How to use that tools is up to the viewers. They can solve engineering problems, create attendance register, maintain Inventory, Billing software etc. I have a video on creating an Invoice template in Excel. Please scroll through the list of my videos to find it.

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

@@XLnCADMalayalam Sure, thanks 😊

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

Very helpful.

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

Thank you

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

NICE...

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

Thank you

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

Clear explanation. Keep it up! I did my task very easily. How can we do VLOOKUP if the data are in different excel files..? Now I copied into a different sheet in the same file. Is there any other option?

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

Thank you so much..❤❤❤

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

You're welcome 😊

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

Excellent class 👍🏻👍🏻👍🏻

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

Thanks sir...

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

So nice of you :)

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

GOOD

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

Thank you

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

Usefull

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

Thank you.

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

Thanks for the video. Very much useful. Where Can i get some exercises for practises?

@faizalceendakath2118 9 месяцев назад

Hi there, if my look up value is a column merged cells, then does it works. ?

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

Select the merged cell and check the address of the cell using Excel Name Box. The same address be used while writing VLOOKUP formula.

@ibaeduworld 2 месяца назад

Sir, oru doubt, ithil idak values absolute akkanamenn paranjit dollar symbol cheyyunnille, actually ath enthina angane cheyyane

@XLnCADMalayalam 2 месяца назад

Check the following video for a detailed explanation on Relative, Absolute and Mixed References in Excel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1Vuyjiw0xYI.html

@swalih-ct1473 3 года назад

🔥❤️🔥🙄

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

😀🙏

@LittleAngeLHAPPYKID 26 дней назад

Absolute pressing... I did not understand, that and F4???

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

Good work. excellent narration, easy to understand

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

Glad you think so!

@shabinp.k2075 4 года назад

തേടിയ വള്ളി കാലിൽ ചുറ്റി...തലക്കകത്തേക്കും കേറി....

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

Ho9iiiiioioooiiioooii

@jamalmuhammeda2538 Год назад

Column index ന് പകരം cell name....ie B2 അല്ലെങ്കിൽ C 2 .... എന്നിവ ചെയ്യാൻ പറ്റുമോ....? കൂടാതെ .... Vlookup ഉപയോഗിച്ച് ചുവട്ടിലേയ്ക്ക് F4 ചെയ്തു drag ചെയ്യാം.... അത് പോലെ Right side - ലെയ്ക്ക് drag ചെയ്യാൻ പറ്റുമോ ......

@mforbes4574 4 месяца назад

Absolutes pressing f4 means?

@sijothekkanath4697 Год назад

how to create daily stock Book mount waise

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

Simply explained.. but why $sign used in formula bar

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

Please go through the comments of this video to know about the use of $ symbol in formulas.

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

Ettavum kooduthal upayogikkapedunna bakki rand functions ethokkeya??

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

Thank you😍

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

My Pleasure. I recommend you to check out my videos on INDEX and MATCH functions. The combination of the INDEX - MATCH functions is more powerful than the VLOOKUP function.

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

@@XLnCADMalayalam hi.. please provide your contact number

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

@@nimin7 If it's a doubt, try to explain it here.

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

I want to learn vlookup for different scenarios

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

Hello Sir, Can you please explain Absolute referencing what you have done in the VLookup formula.

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

I have done a detailed video on this Topic. Please check my recent videos in the videos section.

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

Hi thanks for your vedio...I want to ask you something...I have a materials list arranged in horizontally...I want to make it in vertical material summary...now I am doing with standard link formula...is there any easy method with u...please advise....if there is such vedios please send the link..

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

Please go through the videos section of this channel and refer my videos on TRANSPOSE function and Paste special transpose.

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

Please how to add current time in excel sheet

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

I have videos on TODAY and NOW functions. Please watch that.

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

onnu practice cheyyan vendi chettan cheytha excel file discriptionil edaamo

@XLnCADMalayalam Год назад

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

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

Thankss

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

My pleasure. I hope you have seen my video on Picture lookup in Excel. Moreover, You are welcome to share your ideas and suggestions.

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

How can we add v lookup from another excel sheet.. Pls explain

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

Please check my video on, How to create an Invoice Template in Excel. In that method, Vlookup Function is used to lookup values in a different sheet.

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

V look up il duplication problem engane solve cheyyam

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

FILTER function is the solution for returning multiple matches.

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

how to change number to word if there is any formula or using any VB fiction?

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

I have a video on that. Please go through the playlist for Programming in Excel.

@sarathtp7985 Год назад

Vlookup different work book ലെ ചെയ്യുന്നത് എങ്ങനെയാണ് ?

@XLnCADMalayalam Год назад

I think I have done a video on this topic. Check the videos section of this channel.

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

👍👍👍

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

Sir aaa pay slip onn cheyth kanikkavo

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

Thanks. Sir, I have a doubt, shall we put Employee Name as dropedown list, instead of Employee Code...? I did the same, but the result was an error..

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

Ofcourse we can use Employee Name in the Drop-down list. Note that first column of second argument, i.e. first column of table array should contain these Employee names. Vlookup function search for the lookup value in the first column of table array.

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

Sir Enthinaan dollar sign use cheyyunath.

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

There are 3 types of references in Excel. Relative, Mixed and Absolute. In absolute reference Row and Column index of a reference will be locked. റെഫെറെൻസുകളെ Absolute ആക്കി മാറ്റാൻ ആണ് $ Sign ഉപയോഗിക്കുന്നത്. $ ഉപയോഗിച്ചില്ലയെങ്കിൽ അടുത്ത സെല്ലുകളിലേക്കു ഫോർമുല കോപ്പി ചെയ്യുമ്പോൾ റെഫറൻസ് റീഅറേഞ്ച് ചെയ്യപ്പെടും. Will do a video on References soon.

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

@@AjayAnandXLnCAD thank you

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

@@AjayAnandXLnCAD sir one more doubt ee sign crct avideyaan use cheyendeth

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

Will share a video that explains about different types of references in Excel ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VH0LbZc_Fw4.html

@Fasil-rw6ok 3 года назад

Sir Dropdown list nte source cells same page il thannew veno ? Source cells different sheet aavumbol dropdown list create aakunnilla

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

Source data of the Drop-down list can be in any worksheet of the workbook.

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

Sir entl Tru or fls exact Mach vetunnilla.. Vlookup Ana xlookup cheyyan pattnilla

@anwarsanzasadiq8331 Год назад

👍👍👍👍

@msdivya5001 8 месяцев назад

V look up from pivot table possible ano?

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

Of course we can VLOOKUP from a Pivot Table. But whenever somebody use a Slicer or Filter it can affect the structure of the Pivot Table and the formula may become useless. Better Copy Paste the values from the Pivot Table to some other location and apply VLOOKUP.

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

Sir, ഒരു പ്രശ്നമുണ്ട്.. Name മുഖേന employeesinte joining date കണ്ടു പിടിക്കുമ്പോൾ date കിട്ടുന്നില്ല. പകരം വേറെ ഏതോ ഒരു value ആണ് കിട്ടുന്നത്. Pls help...

@XLnCADMalayalam 2 месяца назад

Maybe the cell is displaying the corresponding number instead of Date. If so, you need to apply Date format to the cell. Right click on the cell > Format Cells... > Date > select the required date format and Click OK

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

Sir, Also, we can use the hyperlink from the right click of the mouse instead of using formulas. Am I right?

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

Yes. We can link cells using the Paste Special option.

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

Nice Class, good going, keep on posting. I need ur help pls find the error on this Vlookup command which used to find the difference from the A column got B column and on C column must be A-B=C used command =VLOOKUP(A1:A72,2,A1:B71,FALSE). Something goes wrong, kindly help to resolve it. rgds Tharun

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

I think you should watch the entire video once again, practice by writing the formula shown in the video and apply it for your situation. Moreover, I recommend my videos on basics to get clear idea about writing Excel formulas.