2010 VLOOKUP & HLOOKUP in MS Excel in hindi

[@FitGrit01]

ehehehheheheheheh,,,,itny easy way ka stya nas kardia mdm apne

[@RahulKumartarghotra]

Im extremely thankful to u
Bahut help mili is video se
Bahut easy way mein aapne itne important topic ko smjhaaya .
10-15 min mein smjh bhi aa gya aur question solve bhi ho gya.
Again extremely thankful 2 u👍👍👍👍👍

[@DailyTechnicalSupport]

Very nice share your nice videos for 2016.

[@ashokkumarrout362]

Thank u so much it's very very helpful to me. It solve my problem today

[@iamthebest2040]

The way teaching was very good useful

[@rajeshkamble6977]

Thank you so much mam its very simple and very easy to learn thank you...kal mera mis ke post ka intrwv hai to ye topic ka bahot help hogi thank you so much

[@vikasshakya8369]

you are very telented I am also a computer teacher but u r great

[@salvindersinghnarwal1473]

Thanks. You explain in a very simple way. need more on advamce excel for accounting purpose
.

[@laxmikantkasralkar3410]

Thanks mam ! Yr teaching method is very easy.

[@pankkajupadhayay7008]

i really apriciate to you mamm, this one is masterpiece thanxx for upload

[@ranjitshintre8538]

Thank you so much ; aapki video dekhkar bahat kuh sikh raha hu...
thank you very much madam

[@deepakkumarbehera8214]

Many many thanks,this video is very excellent.

[@techfort4900]

nice i m able learn about v look up and h look up very well

[@kirankumarchandrasekaran518]

wow superb.thankx so much sister ponnam garg thankyou make me understand so well after 14 years about this.

[@sachinsuryawanshi99]

Aap ka teaching very good

[@azizniazi9159]

special thanks for such an informative video.

[@puneetchauhan1104]

Thanx mam,
Bhut help mili is se

[@rkrecords9993]

nic video mem

[@himanshupanwar6831]

good vlookup &hlookup

[@Happykhalsa]

Ty mam for this video.. gud job mam

[@jbvines3773]

Great teaching Mam thaku so much

[@samkhan6615]

very good vlookup &hlookup thanks

[@abbuabbas7492]

very informative यार. any further video in excel

[@mohdisrar351]

Very good vlookup and hlookup solution

[@maqboolalam4983]

Good teaching👍 and thank u

[@bickyprajapati3584]

appreciated.... very useful

[@jayatomar7287]

👍👌👌

[@welder3000]

you are the best

[@anirudhagirme9295]

Thank you madam. Very nice.

[@ajaygautam4280]

thanx mam you r great 👏👏👏👍👍

[@srinivaspapasani3165]

Good

[@renurawat6922]

very well

[@vivekpadwal147]

Thank you so much...Mam nice solution

[@jameelashah2783]

Thanks
This is very useful

[@ravirock8410]

Nice video

[@kajalsharma5763]

Thnks ..useful video

[@chanchalsingh4318]

thanks mam very helpful video

[@mithileshpatel7013]

It's so good mam

[@jaidevjangra8819]

good

[@netaikarmakar5585]

thank you so much this video...

[@ravindrajadhav1526]

nice mam

[@nandakumardeepaknanda1558]

Super

[@upciss]

maim excel me IRR formula ka video plz...plz....plz...plz...plz...

[@BhaktiDarshan425]

mast

[@Mukeshyadav-ts3mx]

very good

[@salmansurya8459]

Bht bht shukriya

[@milind131]

Nice one

[@zohaibahmad1292]

THANKS GOD BLESS U

[@sarak-0004]

Look green

[@Bandanavlogs143]

Thank u ...Great teaching

[@suratwalas]

Thanks for video

[@kunalyelve4848]

Kya hum ye data new workshit me Kar sakte hai

[@savitasingh4329]

Agar ismai 2 person ka name same hai to vlookup correctly work nhi karta

[@Payalsharma.7]

surname bhi likhna

[@Smiling_star123]

very helpful video

[@dharmendrayadav-bw2gp]

Great

[@sourabhkushwah6777]

nice

[@MrKumar-xu9rl]

thank you Poonam

[@shahidbangash7022]

Thank You so much .

[@gurjithk1992]

Hi can u please explain if i use my customer number and his address automatically fills up.I dont want to have drop down menu .just research box to put customer numbers

[@saddamhussain-ke4cb]

Mam mujhe ye Jan na h ki adanvce exel m kya kya ata h.
Please say to me

[@ramanmalhotra9119]

Agar hum a2 mein koi number jaiseki 100 likhe,aur b2mein bhi koi number jaise ki 35 likhe,phir c2 mein jaiseki "M" likhe, to d2 mein automatic a2*b2 ho jaye , aur e2 mein a2 - b2 ho jaye,lekin jab hum c2mein "N" likhe ,to d2 mein a2+ b3 ho jaye,aur e2 mein a2* b2 ho jaye,uske liye kya karna chahiye?

[@SanjaySharma-zf5mm]

Like this..

[@kakaysingh3574]

Thanku

[@manusharmas19]

Ashish bhai aapki awaz to ladkiyo jaisi h

[@bengali_lady_in_himachal]

Thank you madam 🙏

[@madhusmitamohanty8649]

thanks madam

[@renuchauhan9475]

mam I have applied this formula but my answer is N/A what was the mistake
because after entering the False option salary criteria is not given .

[@shashikantsharma2545]

Thanks ma'am

[@manojkumarthakur7406]

thanx

[@nishathakur3546]

Thanks dear

[@avinashsharma6633]

Thank you

[@romiiii3815]

nc example

[@vijaywin7892]

Thanks a lot

[@MadanSingh-ou9ib]

isse aasan toh mujhe aata hai itna lamba krne ki kya jarrurat hai shortcut maro its a very long command which u use in this video

[@abdulghaffar-tu4ts]

aik jab hm drag karty hn to kuch value show nh karta aur dusra ye ha ager aik he table man salemm, saleem a jay to wo kesay karen first value kon se aye ge jo bari ho ge ya choti ho ge plz lazmi batana

[@brandcutpiecehouse]

fix table array with dollar sign before drag formula

[@PoonamYadav-np9ve]

thank u

[@niveditajage]

Mam mere yaha pe vo function argument me niche fill up karne ke bad =salary dikhai nahi de rahi hai plz batao na

[@niveditajage]

Or enter karne ke bad #REF! Aise aa raha hai

[@asifakhtar8930]

thank u mam

[@govindlal2253]

Thanks..

[@unmeshmakapalle142]

thank u....

[@helaluddin103]

thanks.

[@umesh_lohar]

thnx..

[@kixakhai2699]

kya hum list se nam select krne k bjaye usko type bhi krsaktay hein

[@Ashutosh.Parasar]

ha bilkul bas aapko kewal
Data>Data Validation>list select karne ke baad jo naam chahiye wo likh sakte hain
jaise example:- Kixa,Ramesh,Suresh,4,5,6,....
kewal comma se separate karna hai.

[@kixakhai2699]

thanks bro its working now

[@snipermafia3466]

kyu nahi bilkul type kar sakte hai

[@faizanvaraliya5103]

Table arrey me error aaaraha he
Please help me
I waiting for your response

[@badaldas2113]

Can show vlookup in other from sheet1 to sheet2

[@brandcutpiecehouse]

for this watch my video on my channel

[@DevendraSS]

Thank you so much

[@spidermanyt8819]

Can u help me in excal

[@shubhammaurya5209]

mame iska uge ham kha kar skta hai

[@ShubhamSharma-sh3is]

mem what is the diff b/t vlookup and Hlookup

[@Ashutosh.Parasar]

VLookup is vertical lookup and
HLookup is horizontal lookup
Its depend upon your master file if master file data is horizontal
like this
Sl No. 1 2 3 4 5
Name 1 2 3 4 5
or
Vertical Like this
Sl No Name
1 1
2 2
3 3
4 4
then you have to choose V or H Lookup

[@pradipkumartab1558]

hello, pls ap hum e bata sakte hai, kaise ek cell par cursor (us cell me formula hai) nhi ja raha hai automatically jump kar ke dusre me chala jara hai,
please hep me...
Thans u in advance

[@sacchaikojano4267]

Pradip Kumar Tab tak

[@sacchaikojano4267]

Sir m apko call karna chahta hu per apka no nahi h mere pass

[@snipermafia3466]

pardip cell ko select karke f2 press karo usme crusur aa jayega

[@shahnawazahmed1432]

Nice Video but there is one problem when i want to know either salary or post of the last entity by the use of vlookup then the Excel Show N/A.. please resolve my problem

[@Ashutosh.Parasar]

lock your table_arrey by putting dollar sign by pressing F4 key
like this
=VLOOKUP(A1,$A$1:$D$10,3,false)

[@tammareddytejprakasht.t1885]

Gud corda

[@jasminepathan3301]

Hello copy paste kar sakta h

[@brandcutpiecehouse]

yes

[@LightAtEndOfTheTunnel]

why do we always provides Range_Lookup="False" ? can anybody explain ? thank you.

[@Ashutosh.Parasar]

if you want exact match the you have to use false or you can also use number 0 (Zero).
but if you want to match near about that value then you have to use true or number 1 (one)

[@sandeepkadam2596]

Thanks

[@hamrazahmad850]

THANKS BUDDY GOOD POINT

[@TheEleaca]

Ek jaise Naam huye tab

[@spidermanyt8819]

I need your help

[@siyarammandal1931]

Pehele ap khud sahi se sikho

[@ManishKumar-pd5wo]

yar srsly kitna purane idea nd formula use kia h 2much confusing such a bad useless page

[@hariomsabal6419]

hii

[@video_for_soul9387]

Complicated video

[@mevijay1610]

chai peelo..

[@spidermanyt8819]

Fee sheet I will send you my problem