What is VLOOKUP vs HLOOKUP | MS Excel Malayalam
In this video am going to show you how VLOOKUP and HLOOKUP function will work in different method with multiple examples.
Download file used in the video: drive.google.com/drive/folder...
About MS Excel VLOOLUP and HLOOKP ;
MS Excel offers a Lookup function, that helps you in searching values or data in a particular column or row. The letter V in V-Lookup stands for vertical [column] on the other hand H-Lookup refers to Horizontal [row]. The knowledge and hands-on experience in using VLookup and HLookup functions are mandatory for some collage assignment or jobs.
Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup, for same you can manually double click on it.
For My Previous Video (Just for your ref how Drop list option can implement in a column)
10 Magical Time Saving Tips & Tricks To Make You Excel Expert
• 10 Magical Tricks in M...
#VLOOKUPmalayalam #HLOOKUPmalayalam #ExcelMalayalam
Пікірлер: 78
Thanks Bro..Very valuable and useful video ..
Njan vlookaup padikkan kure video kandu.. Athil onnukoode manasilyath chettande video thanne... Thank you so much sir❤️👍
Nice video bro, very much informative.
This video very usefull ,Thank u sir ❤😍
Its helpful for the students
The best XL tutorial i ever seen, keep it up
@rows_columns
3 жыл бұрын
Glad you think so! :)
Informative video
Thanks Bro I am watching your videos one by one, its really helpful
@rows_columns
4 жыл бұрын
😇
Thank you so much
Nice videos. Thanks a lot, I learnt a lot from your videos. I have a doubt, if we have large data and when we filter the data some rows goes hidden. I tried to vlookup, but error poping up, can you please post a video on this topic.
I am using vlookup function, very useful and multi purpose in excel ever I seen function
@rows_columns
3 жыл бұрын
😊
Very useful😍
Thanks bro
Thank you sir. Super. very useful
@rows_columns
4 жыл бұрын
😊
Thank you so much brother
This video was really useful.. thank you so much ✨😇
@rows_columns
2 жыл бұрын
😻
Nicely demonstrated and very easy to understand. Thank you.
@rows_columns
2 жыл бұрын
Thanks a ton😊
Great sir
very helpful thank you dear sir
@rows_columns
3 жыл бұрын
😇
good presentation...very helpful
@rows_columns
4 жыл бұрын
♥️
Thanks brother . Good presentation.
@rows_columns
2 жыл бұрын
Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates
Thank you so much sir
@rows_columns
7 ай бұрын
Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊
Very useful video ❤❤
@rows_columns
Ай бұрын
Glad to hear that
Hai,i have a file includes employee name and code.and I have got another file with employee names only . Is it possible to vlookup with name to get employee code.Kindly help
Sir in the 1st case for finding the location, its against is name, so how can we select the empl number? I didnt understand
💯💯
Thanks😊
@rows_columns
4 ай бұрын
Welcome 😊
നമുക് name vlook ഇട്ട ശേഷം location വീണ്ടും vlookup ഇടാതെ copy paste chayyathelle annit cell number മാറ്റിയാൽ പോരെ
Please share exel sheet
Thank you
@asharafmuhammed8269
4 жыл бұрын
Thank you!
@rows_columns
2 жыл бұрын
Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates
Thanks a lot, the best in youtube. One doubt: is there a way to lookup a set of data/ like more than 4/5 columns together?Dragging one formula to other cells give answer NA.
@rows_columns
2 жыл бұрын
Thanks😊 Apply absolutely reference & try✌️
@karthikavarma8970
2 жыл бұрын
@@rows_columns yes that works🙏🏻
@rows_columns
2 жыл бұрын
@@karthikavarma8970 💫👍😊
@MaheshKumar-ww4cy
2 жыл бұрын
Apply Absolute reference by pressing F4
3:15 Sir 0 ഇട്ടാലും കുഴപ്പമില്ല എന്ന് പറഞ്ഞില്ലേ. Zero use ചെയ്യുന്നത് എന്തിനാണ് എന്ന് പറഞ്ഞു തരുമോ?
Thanks Alfan sir. How to set a searchable drop down list?
@rows_columns
4 жыл бұрын
Tnx Mate :) We can set up.. same I will upload it soon👍 In sha allah.☺️ Am planning to create full fledged video on Sales, Purchase along with p/L & Inventory.. on that I will explain it🤝
@remo89sr
4 жыл бұрын
@@rows_columns thanks , im waiting. How to create a form without VB?
@rows_columns
4 жыл бұрын
@@remo89sr I will upload the same in coming week👍
Hi Alfan- ഒരു searchable drop down list ഉണ്ടാക്കുന്ന method പറഞ്ഞുതരുമോ
@rows_columns
4 жыл бұрын
Sure... Very soon I will upload the video and share with you🙂👍
@baijukumar9949
4 жыл бұрын
@@rows_columns Thank you
@sahulradhakrishnan9181
10 ай бұрын
Adyam search box undaku ennit data whole ayi click go to conditional formatting use the option the last click ennit select search box = data il 1st cell then delete the dollar sign format option click appol fill ennoru option und select colour then ok
hi Alfan..under vlookup if employee no is in column B and Name is in Column A..how to use the vlookup in this case keeping lookupvalue same as employee no..this is just example from your file, while in many formats we had come across this type of issue..
@rows_columns
4 жыл бұрын
Hi Kiran, That case we can use either X Look up or Index Match... will share the link soon once I make the video😊
@krmnambiar
4 жыл бұрын
@@rows_columns noted with thanks
@rows_columns
4 жыл бұрын
🙂🙂
📌To Learn Microsoft Excel in English, Click on the Below Link: kzread.info/dash/bejne/daJnj8SFdM6tfbw.html
Exact എന്തിനാണ് 0 അല്ലെങ്കിൽ false കൊടുക്കുന്നത്
@rows_columns
2 жыл бұрын
It will treat anything equal to zero (0) as false, anything unequal to zero as true.
Can you send me an excel sheet?
@mohammediqbal2473
3 жыл бұрын
Sir your help to find look up one colom A captain SKUcolom B cantanin location same sku in different location how can get location sku location first colom, location 2 second colom location 3 third colom etc
@mohammediqbal2473
3 жыл бұрын
Pls give Watsapp no.
@bittukthampi
3 жыл бұрын
@@mohammediqbal2473 9746637500
താങ്കളുടെ നമ്പർ തരുമോ sir കുറച്ച് സംശയങ്ങൾ ഉണ്ട് ബുദ്ധിമുട്ടില്ലങ്കിൽ മതിട്ടോ
@rows_columns
3 жыл бұрын
@@sharkwhale1402 send me ur contact details to alfankp86@gmail.com
@sharkwhale1402
3 жыл бұрын
ഓക്കേ sir
Thank you so much
@rows_columns
Ай бұрын
You're most welcome