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.
@@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.
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
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
मुझे आपका समझाया हुआ ही समझ आरा हैं mem ❤ धन्यवाद
Learnt and practiced. Thank you.
Great job!
This is totally wrong way.
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
you made it so simple, thanks
Glad it helped!
😢
Apki awaz bhot sweet hai thank you mam
Last by by got me 😂❤
Thanks for the easy explanation 😊
One of the easiest explanations out there. Thank you
Glad it was helpful!
Super explanation n voice.V,H Lookup has multiple benefits. Teach other uses ❤
Thank You, Sure I will
very well explained. Salute mam :)
Thanks
I love your way to explain❤
Thank you
Thnks mam helpful I'm civil engineer in government it's helps to prepare estimate
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
Vlookup match kaa use karna tha mam
Thankyou so much 😊
Apka batane ka tarika sabse achha laga baki other logo ki video ke according 🥰
Thank you, it means a lot
Bye bolne ke tarike se like karne ka dil kiya ...to kar diya..😂😂😂
Super 👌 ❤ Tq
What a voice, lovely
Wah so esy ...thank you very much
Thanks for liking
Good. Work sister
Very nice video so much
I love you mam, you teaching methood is so awesome!
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
You are right 👍
She is right 😂😂
Thanks 👍 my dear sister ji
Lovee u yaar kya baat hai simple way me bata dia ❤
=vlookup(lookupvalue,table array,{2,3},false) ek baar me hi aa jayega drag karne ke jarurat hi nhi
Correct, I have explained this also in my another short
Very nice miss
Thank you!
Hello mam price column ka column index number 3 rahega na to drag Karne par kaise aa gaya
Please check this playlist: studio.th-cam.com/users/playlistPL8qTPzPvOrCuM-zQUgej6iffCnshkrBFW/videos
Hello mam ye link kis liye share KIYE ho
Thnx uh so much❤
Nice explain 😀
Thank You
Bahot achche se smjh aa gya
Thank You
Apki voice bhut achi hai mam 😁 and formula smjh a gya hai 😍
Simple tha aur samaj agaya didi
Thank You
Working గుడ్ job
=VLOOKUP(lookup_value, table_array, col_index_number,[ range_lookup])
Thanks alot
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
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.
Awesome ❤
You can use index formula in cell 2
Easy Thankss❤
drag option not worked?
Please check pinned comment
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
Won't we say H when asked about column? I'm confused please help
Please elaborate your query for better understanding
Yes,got it VLOOKUP 🎉 thanks mam
Great 👍
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
Amazing ❤
Thanks
Thank you so much
Mast
Nice. Thanks
Thanks 😊
You're welcome!
bybyyy🎉
😊😊😊
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
Full. Computer couree
Please check long video on my channel.
Mam mere N/A bata raha hai.... As it is aapke jesa karne ke bawjood?????????
Please check this video: th-cam.com/users/shortsqNZoSL3ww6E?feature=share and th-cam.com/users/shortsNdS1aU73lto?feature=share
omfg ! thank u
Thank you
Thankss
hlookup formula bahto dear
Channel Par Uploaded Hai, Please Check
Nice
Thanks
Thank you so much
Thank you for this video
More useful to me
Thanks a lot
Glad to hear that
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
Thanks
mam which is this office?
Microsoft office 2016
easyyyyy
Tqqqq
😊😊😊😊
Byeeee
👍🏻
Bbye
Apne galat kiya hh😮.
Apko drag karne se pehle usko lock krna chahiye tha
It's like copy & paste
Thank you, ap jaldi se bol dia 20 minutes ka video me faltu bakwas na karke
Copy paste potlae pothuum
how can you drag the value without freezing the lookup value? wrong explanation!
Please check pinned comment also check the long video
Mera n hua yrr
False and true kyu likhte hai?
TRUE for approximate match and False for exact match
Bhai me Sikh gya 😢
Love u
Nahi aa rha hai mera
Please check this video: th-cam.com/video/UF8qTivePeE/w-d-xo.html
Very good
Thank you!!
ta ta
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
=sun (h3%i4)ENTER
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: th-cam.com/video/vNmczNhX8Bo/w-d-xo.html
Bye bye mam
Thanks
Thank you
Thank you