Hey Viewers, there is an update. In this video you need to freeze the lookup value and table array also need to use column function in the place of column index number. I have explained all the thing in my another videos.
Cell range lock kiye bina formula drag krne par formula me cell range bui change ho jayega to ye formula kaam nahi karega jaisa apne bataya hai is video me
@@dheerajsingh4462 I am not from civil engineering background so I don't know ki actual konse formulas use hote hai but I will research and try to make video on that.
@@GrowWithSkills jese pivot table,data sorting & analysis, billing and estimation formats etc. Baki basic aur formule ki to h videos..so..try to make a video on it.. as early as possible.
Hey Viewers, there is an update. In this video you need to freeze the lookup value and table array also need to use column function in the place of column index number. I have explained all the thing in my another videos.
@@GrowWithSkills thankyou my favourite ms Excel give me more formula function
I don’t even speak Hindi but I understand. Your use of example is very easy to follow. Well done!
Thank You!
Sir I want fluent speak english how do
Learnt and practiced. Thank you.
Great job!
This is totally wrong way.
मुझे आपका समझाया हुआ ही समझ आरा हैं mem ❤ धन्यवाद
madam mujhe aj tak vlookup formula use main lena NAHI AAYA LAKIN AAPKE VIDEO SE ITNA EASILY SIKH GAYA OR KAM EASILY HO GAYA THANKU
Thank You! Keep Watching
Apki awaz bhot sweet hai thank you mam
Thnks mam helpful I'm civil engineer in government it's helps to prepare estimate
Thank You!
Very nice video so much
Thanks for the easy explanation 😊
Vlookup match kaa use karna tha mam
Working గుడ్ job
Good. Work sister
Super explanation n voice.V,H Lookup has multiple benefits. Teach other uses ❤
Thank You, Sure I will
I love your way to explain❤
Thank you
you made it so simple, thanks
Glad it helped!
😢
Last by by got me 😂❤
One of the easiest explanations out there. Thank you
Glad it was helpful!
You are right 👍
She is right 😂😂
Thank you so much
Thank you
Wah so esy ...thank you very much
Thanks for liking
Apka batane ka tarika sabse achha laga baki other logo ki video ke according 🥰
Thank you, it means a lot
Nice explain 😀
Thank You
I love you mam, you teaching methood is so awesome!
Thankss
Thanks alot
very well explained. Salute mam :)
Thanks
What a voice, lovely
Super 👌 ❤ Tq
Thnx uh so much❤
Very nice miss
Thank you!
Quantity ke liye VLOOKUP kaun lagata hai Di???
Apko price ke liye lagana tha aur col index 3 lena tha
Yes, aap bilkul sahi kah rahe hai
Easy Thankss❤
Didi aapne toh Jadu kar diya... Kisi ka vlookup mujhe nhi a rha tha aaka ka toh jaise koi mazik ki tarha ho gya vloookup
Thank you
Awesome ❤
Bahot achche se smjh aa gya
Thank You
Lovee u yaar kya baat hai simple way me bata dia ❤
Bye bolne ke tarike se like karne ka dil kiya ...to kar diya..😂😂😂
Thankyou so much 😊
Cell range lock kiye bina formula drag krne par formula me cell range bui change ho jayega to ye formula kaam nahi karega jaisa apne bataya hai is video me
I have Explained all the details on long video. Please check that too.
@@GrowWithSkills to ye kya baat Hui. Ek video me adhuri jankari de Rahi ho AAP.
Thanks 😊
You're welcome!
Simple tha aur samaj agaya didi
Thank You
Nice. Thanks
This is great tutorial saved our time. Appreciate your work mam. Some people will take 5-10 minutes to explain this😂 for making video more lengthy
Thank You
You can use index formula in cell 2
Kon sa formula kab lagana h..kese pata chalta h..qki bahut sare formule hote h...exact ka pata kese kare?
Koi bhi formula yaad karne ki need nahi hai with practice apne aap clear ho jaega.
@@GrowWithSkills to...ek video banay civil engg. me excel me kya kam hota h..aur usse related formule kon se h...
@@dheerajsingh4462 I am not from civil engineering background so I don't know ki actual konse formulas use hote hai but I will research and try to make video on that.
@@GrowWithSkills jese pivot table,data sorting & analysis, billing and estimation formats etc. Baki basic aur formule ki to h videos..so..try to make a video on it..
as early as possible.
Ya ham logo ke upper depend karta hai ki hame Kitna knowledge hai yadi excel ka sahi se knowledge ho gaya to appne se formula use Karne lagoge
Amazing ❤
Thanks
Nice
Ma'am drag karne par nahi ho Raha kya problem ho sakta hai
Please check pinned comment apko vlookup + column function use karna hoga. Channel par video hai aap check kijie clear ho jaega
Thanks
Mast
Hello mam price column ka column index number 3 rahega na to drag Karne par kaise aa gaya
Please check this playlist: studio.ruclips.net/user/playlistPL8qTPzPvOrCuM-zQUgej6iffCnshkrBFW/videos
Hello mam ye link kis liye share KIYE ho
Price mein kese apply kare??? Price nikal rahe h toh N/A aa raha h 2,0 ke liye bhi nhi aa raha
Aapko column function use krna hoga column index number ki jagah channel par video hai aap wo dekh skte hai
Apki voice bhut achi hai mam 😁 and formula smjh a gya hai 😍
omfg ! thank u
Tqqqq
Thank you for this video
More useful to me
Thanks a lot
Glad to hear that
Full. Computer couree
Please check long video on my channel.
Yes,got it VLOOKUP 🎉 thanks mam
Great 👍
easyyyyy
Mam mere N/A bata raha hai.... As it is aapke jesa karne ke bawjood?????????
Please check this video: ruclips.net/user/shortsqNZoSL3ww6E?feature=share and ruclips.net/user/shortsNdS1aU73lto?feature=share
Won't we say H when asked about column? I'm confused please help
Please elaborate your query for better understanding
Thanks
Thank you so much
hlookup formula bahto dear
Channel Par Uploaded Hai, Please Check
Fillter use kar sakte hai na itna karni ki kya zarurat
Kar Sakte ho but what if data another sheet or workbook mai manga jae?
Right 👍 👍 I forgot that 😅@@GrowWithSkills
bybyyy🎉
😊😊😊
It's like copy & paste
😊😊😊😊
👍🏻
Mera n hua yrr
mam which is this office?
Microsoft office 2016
Bhai me Sikh gya 😢
False and true kyu likhte hai?
TRUE for approximate match and False for exact match
Copy paste potlae pothuum
Apne galat kiya hh😮.
Apko drag karne se pehle usko lock krna chahiye tha
Very good
Thank you!!
Nahi aa rha hai mera
Please check this video: ruclips.net/video/UF8qTivePeE/видео.html
how can you drag the value without freezing the lookup value? wrong explanation!
Please check pinned comment also check the long video
Love u
Bbye
Thank you, ap jaldi se bol dia 20 minutes ka video me faltu bakwas na karke
=sun (h3%i4)ENTER
Didi v look up ko dreg nahi kar sakte kuki lookup dreg nahi hota
Drag Kar sakte h with column and Row Function. Mene Us par bhi Video Banai Hai.
Vlookup ko horizontal and vertical dono ek sath drag kar sakte hai eske liye hame column and row ko avsakta anusaar fix ttha unfix Karna hota hai
ta ta
B by😂
Hiii mam
VLOOKUP/HLOOKUP madhye kiti parameters mhnje approximate match hotat.
Bekar function
Useless
Mere computer me nai hora hai
Please check this video: ruclips.net/video/vNmczNhX8Bo/видео.html
Bye bye mam
Thank you
Thank you