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.

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

#VLOOKUPmalayalam #HLOOKUPmalayalam #ExcelMalayalam

[faizalabdulrahim]

Thanks Bro..Very valuable and useful video ..

[siyad]

Njan vlookaup padikkan kure video kandu..
Athil onnukoode manasilyath chettande video thanne...
Thank you so much sir❤️👍

[prasadrk]

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.

[pearlsypriya]

Nicely demonstrated and very easy to understand. Thank you.

[Noufalmrc]

I am using vlookup function, very useful and multi purpose in excel ever I seen function

[rows_columns]

📌To Learn Microsoft Excel in English, Click on the Below Link:

[midhunthankachan]

Thanks Bro I am watching your videos one by one, its really helpful

[sreekuttypm]

This video was really useful.. thank you so much ✨😇

[Mhd_Bilal___]

This video very usefull, Thank u sir ❤😍

[me.nandan]

Nice video bro, very much informative.

[udayankandy]

The best XL tutorial i ever seen, keep it up

[gottigere]

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

[ShiginGangadhran]

In comparison for me only two data getting displayed remaining it shows Nil may i know the reason

[devams]

3:15 Sir 0 ഇട്ടാലും കുഴപ്പമില്ല എന്ന് പറഞ്ഞില്ലേ. Zero use ചെയ്യുന്നത് എന്തിനാണ് എന്ന് പറഞ്ഞു തരുമോ?

[abhizuk]

Sir in the 1st case for finding the location, its against is name, so how can we select the empl number? I didnt understand

[karthikavarma]

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.

[afsaljaffar]

നമുക് name vlook ഇട്ട ശേഷം location വീണ്ടും vlookup ഇടാതെ copy paste chayyathelle annit cell number മാറ്റിയാൽ പോരെ

[remosr]

Thanks Alfan sir. How to set a searchable drop down list?

[baijukumar]

Hi Alfan- ഒരു searchable drop down list ഉണ്ടാക്കുന്ന method പറഞ്ഞുതരുമോ

[sharkwhale]

താങ്കളുടെ നമ്പർ തരുമോ sir കുറച്ച് സംശയങ്ങൾ ഉണ്ട് ബുദ്ധിമുട്ടില്ലങ്കിൽ മതിട്ടോ