VLOOKUP in Excel - Malayalam Tutorial
ലോകത്തിൽ ഏറ്റവും കൂടുതലായി ഉപയോഗിക്കപ്പെടുന്ന മൂന്ന് എക്സൽ ഫങ്ഷനുകളിൽ ഒന്നാണ് വിലുക്കപ്പ് ഫങ്ഷൻ. എക്സലിലെ വിലുക്കപ്പ് ഫങ്ഷന്റെ സാധ്യതകളെ കുറിച്ച് വിശദീകരിക്കുന്ന വീഡിയോ.
How to use the VLOOKUP function in Excel is explained with 3 different examples.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-mi...
മൈക്രോസോഫ്റ്റ് എക്സൽ ഇത് വരെ ഉപയോഗിച്ചിട്ടില്ലാത്തവർക്കും, പഠിച്ചു തുടങ്ങാൻ ആഗ്രഹിക്കുന്നവർക്കും വേണ്ടി . . .
• Microsoft Excel Tutori...
#ExcelMalayalam #VlookupMalayalam #VLookup
Пікірлер: 249
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
എക്സാമ്പിൾ ആണ് നന്നായതു.. അല്ലെൻകിൽ ചിലപ്പോൾ മനസിലാകില്ലാരുന്ന്.. താങ്ക്സ്
Very good explanation simple and useful 👍🏻👍🏻👍🏻
നിങ്ങൾ പൊളിച്ചു.... Ethrem simple aaytt no one can teach..... Great wrk sir and also thank u so much
@XLnCADMalayalam
3 жыл бұрын
😀🙏Thank you
Great class👍👍..very helpfull
You examined well God bless
explaining in a very simple and systematic manner!! good job, all the best!
@XLnCADMalayalam
3 жыл бұрын
Glad it was helpful!
Thank you so much
It's very useful knowledge to all excel users, simply explained.. Thanks a lot...
@XLnCADMalayalam
4 жыл бұрын
My pleasure 😊
Thank you so much sir. This session was useful for me.
@XLnCADMalayalam
4 жыл бұрын
My pleasure :)
Adipoli
Thanks വളരെ നല്ല explanation.
@XLnCADMalayalam
4 жыл бұрын
Glad to hear that. and thank you for posting feedback.
Simple and clearly explained..thank you😊
@XLnCADMalayalam
4 жыл бұрын
My pleasure.
Thanks, It's really helped me to lean this function.
@XLnCADMalayalam
Жыл бұрын
😀👍
നിങ്ങളൊരു ഭായി ആണ് ഭായ്. അടിപൊളി
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?
Excellent class 👍🏻👍🏻👍🏻
THANKS A ALOT SIR,I have useful these vedio
@XLnCADMalayalam
4 жыл бұрын
You are welcome
Very helpful
Awesome, this was super helpful.
@XLnCADMalayalam
Жыл бұрын
Glad to hear that :)
Thank you..
Thank You very much, It is very clear.
@XLnCADMalayalam
8 ай бұрын
Glad it helped!
Superb… informative… thanx…. 👌👌👏👏👏👏
@XLnCADMalayalam
Жыл бұрын
Most welcome 😊
Well explained. you videos are awesome. Thanks
@XLnCADMalayalam
Жыл бұрын
Glad you like them :)
Very useful video, thank you..👍
@XLnCADMalayalam
6 ай бұрын
Glad it was helpful!
Mikacha avatharanam👍
Great work simply awesome 👌👌
@XLnCADMalayalam
Жыл бұрын
😀👍Thank you
Your great sir, simple presentation Thanks very much sir
@XLnCADMalayalam
2 жыл бұрын
My pleasure 😀
Thankyu sir
@XLnCADMalayalam
2 жыл бұрын
My pleasure😀
Thanks for the video. Very much useful. Where Can i get some exercises for practises?
ഗുഡ്
thank you sir. great effort.
@XLnCADMalayalam
4 ай бұрын
You are welcome 😀
Very useful VLOOKUP formula vedios that you Sir
@XLnCADMalayalam
4 жыл бұрын
Thanks and welcome
Kidu
@XLnCADMalayalam
Жыл бұрын
Thank you :)
Very much helpful and informative, Liked the way of teaching is simply awesome... keep going 🙌
@XLnCADMalayalam
Жыл бұрын
Glad to hear that 😀
Good. Very informative
@XLnCADMalayalam
3 жыл бұрын
Glad you liked it
Useful Tutorial.
@XLnCADMalayalam
4 жыл бұрын
Glad to hear that
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
Thank you so much..❤❤❤
@XLnCADMalayalam
4 жыл бұрын
You're welcome 😊
Super
Super class. Thank you
@XLnCADMalayalam
4 жыл бұрын
You are welcome
Nice
Thanks.it helped alot
@XLnCADMalayalam
2 жыл бұрын
You're welcome!😀
Thanku
@XLnCADMalayalam
3 ай бұрын
😀👍
Great
@XLnCADMalayalam
Жыл бұрын
😀👍
Thank you sir
@XLnCADMalayalam
2 жыл бұрын
My pleasure :)
Thanks u sir, superb class 👍
@XLnCADMalayalam
Жыл бұрын
My pleasure :)
Excellent presentation
@XLnCADMalayalam
4 жыл бұрын
Glad you liked it
Very useful videos.. Pls keep doing it
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Very helpful.
@XLnCADMalayalam
4 жыл бұрын
Thank you
clear explanation ❤️
@XLnCADMalayalam
2 жыл бұрын
Glad it was helpful!
Very useful video sir
@XLnCADMalayalam
4 жыл бұрын
Glad to hear that and Thanks.
Good👍🏻
@XLnCADMalayalam
Жыл бұрын
😀👍
Good Explanations
@XLnCADMalayalam
4 жыл бұрын
Thank you ☺️
very good class
@XLnCADMalayalam
Жыл бұрын
Thank you😀
Very useful video
@XLnCADMalayalam
4 жыл бұрын
Thank you. I recommend my video on XLOOKUP too.
Thank you 😘
@XLnCADMalayalam
4 жыл бұрын
You're welcome 😊
Thanks
@XLnCADMalayalam
3 жыл бұрын
Welcome
Superb class....👍
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Thanks sir...
@XLnCADMalayalam
4 жыл бұрын
So nice of you :)
NICE...
@XLnCADMalayalam
4 жыл бұрын
Thank you
Start learning Microsoft Excel in Malayalam kzread.info/dash/bejne/hqqZyKWblZzZY5M.html
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.
Usefull
@XLnCADMalayalam
4 жыл бұрын
Thank you.
👍👍👍
Thankssssss
@XLnCADMalayalam
3 жыл бұрын
My pleasure :)
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 😊
GOOD
@XLnCADMalayalam
4 жыл бұрын
Thank you
👍👍👍👍
Absolutes pressing f4 means?
Sir entl Tru or fls exact Mach vetunnilla.. Vlookup Ana xlookup cheyyan pattnilla
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.
how to create daily stock Book mount waise
Ettavum kooduthal upayogikkapedunna bakki rand functions ethokkeya??
Column index ന് പകരം cell name....ie B2 അല്ലെങ്കിൽ C 2 .... എന്നിവ ചെയ്യാൻ പറ്റുമോ....? കൂടാതെ .... Vlookup ഉപയോഗിച്ച് ചുവട്ടിലേയ്ക്ക് F4 ചെയ്തു drag ചെയ്യാം.... അത് പോലെ Right side - ലെയ്ക്ക് drag ചെയ്യാൻ പറ്റുമോ ......
👍👍👍👍👍👍
Sir aaa pay slip onn cheyth kanikkavo
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.
തേടിയ വള്ളി കാലിൽ ചുറ്റി...തലക്കകത്തേക്കും കേറി....
@revloges2952
4 жыл бұрын
Ho9iiiiioioooiiioooii
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.
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.
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.
Hi there, if my look up value is a column merged cells, then does it works. ?
@XLnCADMalayalam
8 ай бұрын
Select the merged cell and check the address of the cell using Excel Name Box. The same address be used while writing VLOOKUP formula.
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.
Sir, oru doubt, ithil idak values absolute akkanamenn paranjit dollar symbol cheyyunnille, actually ath enthina angane cheyyane
@XLnCADMalayalam
Ай бұрын
Check the following video for a detailed explanation on Relative, Absolute and Mixed References in Excel. kzread.info/dash/bejne/Y4qp28yip5Peiaw.html
🔥❤️🔥🙄
@XLnCADMalayalam
2 жыл бұрын
😀🙏
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
Good work. excellent narration, easy to understand
@XLnCADMalayalam
4 жыл бұрын
Glad you think so!
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.
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.
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.
Sir, absolute(f4) function enthinan use cheyyunath ?
@XLnCADMalayalam
4 жыл бұрын
ABS function (absolute function) and Absolute reference are different. 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. Everyone who use Excel formulas, should know this difference to write and use formulas efficiently. Will do a video on this topic soon.
very informative and highly appreciated for your video in fact I was looking for this in KZread and luckily found your video which is well explained and simple to understand. I have a doubt, what is this HLOOKUP function used for?
@XLnCADMalayalam
4 жыл бұрын
Glad it was helpful! VLOOKUP stands for Vertical Lookup. Similarly, HLOOKUP is for Horizontal lookup.
@sonythomas100
4 жыл бұрын
@@XLnCADMalayalam oh I see thanks for the information
Oru excel sheet il already ulla data full work out cheithathinu sesham athinte oder mari poyal athinte original order leku engane matan patum
@XLnCADMalayalam
3 жыл бұрын
Read about helper columns. These are used to bring back data into the previous order.
Hi, how to use vlookup with multiple cell values
@XLnCADMalayalam
3 жыл бұрын
Can you please explain the question with an example?
Sir first sheetil in data vere sheetil return cheyyan pattuo..? I mean , sheet 1 il illa raw data sheet2 il return cheyyanam..
@zid1072
10 ай бұрын
Possible
V look up il duplication problem engane solve cheyyam
@XLnCADMalayalam
3 жыл бұрын
FILTER function is the solution for returning multiple matches.
Please how to add current time in excel sheet
@XLnCADMalayalam
3 жыл бұрын
I have videos on TODAY and NOW functions. Please watch that.
Sir, v look up use cheyth Rand work bookile datas duplication ullath kand pidikan patumo? Enkil athengananenn paranj tharumo?
@XLnCADMalayalam
3 жыл бұрын
Please go through my videos. I have done separate videos on 'How to find Duplicates' as well as 'How to remove Duplicates'
@mariyak.v1374
3 жыл бұрын
@@XLnCADMalayalam Thank u Soo much sir
@mariyak.v1374
3 жыл бұрын
@@XLnCADMalayalam But sir , ath Oru sheetile duplicates kand pidikanulla video alle? Njn chothichath Rand work bookile allenkil Rand sheetile ore polulla datas kandu pidikan ayirunnu. Vlookup use cheyth athengane cheyyumenn idea kitunnilla.athonn paranj tharumo
@XLnCADMalayalam
3 жыл бұрын
VLOOKUP is meant to return a value or values corresponding to the lookup_value or the searched value. If you want to compare the values in two different cells, you should use IF function. I have explained about IF function in the Video called 10 Most used formulas in Excel. Another way to compare data in different cells is using the = operator. For example, the formula =A1=B1 will return TRUE if the values in A1 and B1 are same and FALSE if the values are different.