MS EXCEL-VLOOKUP & HLOOKUP FUNCTION -Hindi|About Vlookup,Hlookup Formula in Excel|Part-1 Basic

Learn What is V lookup and H Lookup also known as vertical lookup and Horizontal Lookup formula. it is most important tool for excel learners or it is great tool for job seekers. It helps us to find particular values from another table. Use vertical lookup function of excel we search values vertically and using horizontal lookup we search values horizontally form another excel table. Helpful in all Types of computer courses such as RSCIT, CCC, O level, PGDCA, Basic Computer course etc. You can Learn and Improve Your Basic computer skill as well as Office Productivity Skill.
Thanks for Watching!!!
Have a Nice Day!
Watch all MS Office Hindi Tutorials-(Learn Basic Computer)- for RSCIT, CCC , O Level and PGDCA Courses- • RSCIT Computer Course|...
Visit Our Website:
www.cpitudaipu...
Visit Our Blog:
cpitudaipur.bl...
Like Our Facebook Page:
/ cpitudr
Please Subscribe to Our Channel
/ @careerp

[@ammyvinayak5970]

Sir thanks aapki smjhai hui hr cheez ache se smj aati h

[@careerp]

+BBS Video ,most welcome, keep learning

[@anuj66438]

Superb sir and thank you for informing advance Excel

[@jawharmondal7117]

Bohut accha lag sir

[@meghanadighe6421]

Very nice teaching technique 👍

[@careerp]

Thanks and welcome

[@kalyaniborse4738]

Thank you so much sir..even after going through many videos I was unable to understand v look up. But u helped me to get the concept

[@careerp]

Thank you so much, keep learning👍

[@PKY9795]

Sir row date hai collm me name uska weakoff date nikaln

[@sagarkhune7932]

Clear teaching.

[@careerp]

Thanks💐

[@mohansinghrawat7862]

Superbb sir ..

[@furqankhan8538]

Thanku sir,
Ek hi baar me vlookup , Hlookup aa gya thanku very much

[@careerp]

Most welcome, keep learning💐💐

[@punamwankhade3991]

Sir please post a pivot table video

[@my_vlogs2618]

Thanks sir 4 learning vlookup nd Hlookup

[@careerp]

Most welcome💐

[@Abbasali4000]

Thanks for teaching Sir. I like your teaching style it's easy to understand. Thanks again appreciate your work 👏👍

[@careerp]

Most welcome, keep learning👍

[@OMYadav-gs9ck]

Hi,
Sir Ji
Your Video lecture r very easy and helpfull Plz share me all topic of Advance excel...
Thanks Regard

[@careerp]

👍

[@zackryder967]

actually sir 1 question hai humne dialog box khole vlookup ka to directly $ sign array table me daal skte hain ya uske kuc consequences hai ????

[@careerp]

$ direct use kar sakte hai

[@poojabarvesohani8015]

thank you its very nice way of teaching

[@careerp]

+Pooja Barve Sohani , most welcome, keep learning

[@sheetalshinde6785]

Thank you so much sir. Your way of teaching simple but effective.God bless you
How to make label in MS-word?
Plz make video

[@careerp]

👍👍👍

[@ajabgajab3543]

Very nice video sir

[@careerp]

Thanks

[@sudiptodolui833]

F4 she table arrey ko directly fixed kr sakte hai...ap but Lt me kr the ho

[@prashantjadhav7212]

easy to understand and very helpful thanks sir

[@careerp]

Most welcome, keep learning😊

[@parabkapil8894]

Very nice explained..
Excellent

[@careerp]

+parab kapil ,thanks

[@archanaaa2514]

Sir while selecting d range it taking as table name. Not range. How to use f4 for table name. How to solve dis issue

[@bhuplink]

Very nice and simple explanation

[@careerp]

Thanks

[@SantoshKumarSingh-nb9sj]

Dear Sir
I want to know how to creat powerpoint by defult page as per my formating.
Please just you reply sir because this is very arjent for me.

[@soniyasen7085]

Nice vedio sir very usefull

[@careerp]

Thanks

[@foodiedasbrothers7185]

nice videi sir very good sir & thankyou sir help your share video thanks sir

[@careerp]

Most welcome, keep learning👍

[@shaikhaqsa3191]

Dolar ki sign enter krne k bjaye ham agar column ya row index no k aage coma zero insert kr k breaket close kre ge tbhi hamara answer correct ayega

[@petlover1988]

Thank you Sir.

[@careerp]

You are most welcome

[@shahhussain4402]

Sir i have learn more then my teacher here

[@careerp]

Keep learning🙏🙏

[@adankhan8266]

very informative good

[@careerp]

Thanks

[@aarohi7342]

Really a helpful video thanku sir

[@careerp]

Most welcome💐

[@yatendrabhati6480]

It's all right

[@prafulkanode575]

sir mera water supply ka kaam hai to me usme pura stock maintain krna h chahata hu For Exp. Jese kitni bottles due hai kitni sale huyi aur kitni stock me hai wo sab kese maintain karu sir plz us pr ek video bana dijiye

[@careerp]

Plz aap stock item ki detail or gst detail send kare, aapke business ki detail batana

[@mahadevamathsacademy4216]

I LIKE UR VIDEO SIR THNX FOR THE LEARNING EXCEL

[@careerp]

+Shivani Sharma ,most welcome, keep learning

[@jyotisharma3717]

thanks sir very helpful vedio

[@careerp]

+Jyoti Sharma ,welcome

[@sambhavidubey6768]

Thank you so much sir
It's very nice video

[@careerp]

Most welcome💐

[@ibraheemmshezad400]

very nice g

[@careerp]

Thanks

[@tilakrajneopane1117]

Gud vdo ,thnks sir

[@careerp]

Welcome

[@RahulSharma-ex4ms]

Acha samjate h, good

[@careerp]

Thanks💐

[@shadabpatel]

ek no

[@careerp]

+shady patel ,thanks

[@sagarghadge3784]

Nice tutorial

[@careerp]

Thanks

[@arijeetkumarsharma226]

Superb

[@careerp]

Thanks💐

[@SanjayKumar-yx6gc]

Thank you so much, taught us look up formula. We wait your next advanced lookup video.

[@careerp]

Most welcome sanjay...

[@nawabsharif2732]

This video very nice

[@careerp]

+khaja hussain ,thanks

[@raghuramans3242]

very helpful

[@careerp]

Welcome

[@sofiqulislamnur6079]

Thanks a lot,

[@careerp]

Welcome

[@sayaliphadtare776]

Very usefull😎

[@careerp]

+Sayali Phadtare ,thanks

[@mukeshmistree7375]

Nice video

[@careerp]

Thanks

[@mohammedwazid5471]

Sir Excel me school ka management like marksheet, admission,fees, staff etc ka automatically kese kare
For exm. Mene marksheet ka data fill kiya ab muje one click se marksheet print karna hai , one student ki....

[@VishalYadav-fc4ny]

Very easy uh made that thank you

[@careerp]

Thanks

[@tradetea9432]

One more question
How can I vlookup onword columns without selecting Range everytime in other files....🤔

[@harshashamla8418]

Thanks sir

[@careerp]

Welcome

[@suhinitasinha7234]

great

[@careerp]

Thanks

[@sachinmohankar5839]

Nice information thank u.....

[@careerp]

+sachin mohankar ,welcome

[@baidyanathlucky3871]

This formula not work with a long table range_row 400@column2 why plz tellme

[@sumitrachauhan6839]

Sir vlookup ड्राप डाउन, auto function, के साथ gst invice बनाइये जिसमे सब auto fille हो

[@rajarani6108]

NICE

[@careerp]

+Chandan Kumar ,thanks

[@chauhanenterprises342]

Table array select krke sir F4 press kariye

[@pushpendrasisodiya5650]

Sir vlookup use karne ke baad agar main apni excel file band karta hu aur fir usi file ko fir open karta hu to usme nai file open hoti hain usme three option milte hain update and don't update aur help inme se kaun sa option per click karna hain

[@careerp]

+Pushpendra Sisodiya ,update

[@jain_mohitkumar]

Thank you sir

[@careerp]

most welcome Mohit...

[@Vlogs0310Chintu]

A1

[@bilalchandio1]

Precious

[@careerp]

thanks

[@ajabgajab3543]

Double vlookup per video banaye sir ji

[@bashirahmedburli8548]

How to run existing company in pen drive

[@powerofsimplicity4918]

Sir, Namskar
I'm Basanta sir excel me total kitna formula hai

[@premanandamohapatra5390]

Basanta Sahu 10

[@premanandamohapatra5390]

10nos

[@tradetea9432]

=vlookup(.....
After that I want to open dialogue box instead of writing everything, so how I can open this without clicking on fx using mouse.

[@sonakshithakur9158]

apko jha p answer chahiye wha p =vlookup likhne k baad ctrl+a kp press kijiye dialog box easilye khul jayega

[@parikaur8823]

agar dursri table me code assending oder me h to ans sahi h agr code uppar niche h to to ans glt h kuch post ka aaisa kyu

[@sachinchauhan6853]

Good viedo

[@careerp]

+Sachin Chauhan ,thanks

[@ranvir0392]

Sir tally me automobile accounting. Bataiye

[@परम्आतम्ज्ञान]

101 se 105 me alawa 123 code ho to answer kya àyega

[@sanjaymaharana8474]

Xnpv or xirr function me vedio banaiye sir

[@parikaur8823]

i dont know sir mere pas window 7 h but this formula not working i don't know why

[@niteshchauhan516]

Agar aap range lookup mein 0 enter karoge toh apka answer aa jayega or apko dollar sign lagane ki bhi jarurat nahi padegi

[@PRK777]

Next video jaldi dalo

[@Aamirkhan-zu6nn]

Plz.
Improve the pic quality....
Tnz

[@studyingdelights5458]

press function key+f4 to insert dollar

[@sanjaypati5077]

sir app ek date wise patten ko leke vlookup ,hlokkup and sumif use kijiye like example-date monthly 1/10/2018 to 30/10/2018,name of employe,department, product ,monthly sale and total sale.find karna hai kunsa employee kiss date main kitna monthly sale kiaa hai and uska kunsa department hai ,uska kita total sale hai.i am waiting your respond sir.please sir esii example ko leke jarooro ek video upload kajiye ga.

[@careerp]

👍

[@nmsjaipur4160]

i am tring as per vdo, but not correct result.,

[@sandeepj5908]

nice information

[@careerp]

+Sandeep Jakkal ,welcome

[@ravendrarewa2001]

Sir formula send kijiye Hlookup ka

[@FaCtSKnOwLeDgERAVI]

,👍

[@AnilPal-xl7po]

sir all command ko bata dijiye

[@ibraheemmshezad400]

koi apni serios ho jis sa koi softwears ka notes mill jain taka seekany main or asani ho to bata dain g

[@anjaneyalorrysupplyofficek8552]

IN A SINGLE ROW DIFFERENT RATE GIVEN EXAMPLE 250,275,280,350,360,380,400,278. LAST AMOUNT SHOULD REPLACE WITH UPPER ROW HIGHER AMOUNT AUOMATICALLY

[@ashutoshsingh-yx9zl]

Mere me to ref likh kar aa raha hai kyo

[@rohitmasih2790]

rahul masih

[@parikaur8823]

mene use kiya pr kuch post ke nam glt aa rhe h plz tell me

[@chetanutk]

pari kaur is formula ko use karne ke baad ise lock bhi karna padta hai, lock larne ke liye jis cell me formula hai use click karne ke baad shift+F4 press kro

[@kalyaniborse4738]

Chetan Kumar do we have to select entire row/Colombia or only first cell of respective Colomn/row?

[@kumarnaik4261]

Sir Excel basic video send Sir

[@careerp]

+kumar naik k ,links given in discrption

[@m.jtechnology1906]

$ka singn lagate wakt 4444444444444 number repeat ho raha hai enter dabane se pehle

[@sonakshithakur9158]

doller sign aap f4 ko press kr k laga skte ho or baki jo apko hatana ho to backspase s hata skte ho thankyou

[@0689Nick]

i cant get any, its bouncer , sorry

[@m.jtechnology1906]

$ki jagah koi bhi chlan nahi to s akte example rupees sign

[@m.jtechnology1906]

Why 44444 reapeat kyun ho rahan jab $sign lagane ke time per enter davbane se pehle ?

[@sonakshithakur9158]

ap doller sign lagane l liye data table ko salect karne k baad f4 press kro easily doller sign aa jayega

[@surajyadav4860]

Sir
Bad me kuchh samagh nhai aya

[@smileplease3652]

Whai is vlookup

[@Msr.shaikh482]

Thoda thik se batana yaar
Kya batara kuch bhi samajh me nhi aara

[@wasimansari8242]

Very nice video sirji

[@careerp]

+Wasim Ansari ,thanks

[@bachchanyadav669]

Nice video

[@careerp]

+Bachchan Yadav ,thanks

[@prekshabhatt1410]

very helpful

[@careerp]

+Preksha Bhatt ,thanks

[@banajabasiniswain4205]

Thank u sir

[@careerp]

Welcome

[@sumitrachauhan6839]

Thanks sir

[@careerp]

+Sumitra Chauhan ,welcome

[@kuljitkumar758]

thanks sir

[@careerp]

+Kuljit Kumar , most welcome...

[@careerp]

+Kuljit Kumar , most welcome...