Vlookup Very Easy | Urdu Hindi | Data Samajh

[@shahidmasroor8670]

according to my knowledge its first pakistani channel explaining excel competing indian channels

[@prinicipalmodel5274]

بہت اچھے طریقے سے آپ سمجھاتے ہیں.

[@DataSamajh]

bohht shukriya janab!

[@muzaffarsyed6999]

گریٹ

[@DataSamajh]

Cool

[@z.masoodmasood180]

اسلام عليكم کھرل صاحب ماشاءاللہ آپ بہت اچھا کام کر رہے ہیں۔ مجھے نمازوں کی کیلکولیشن پہ شیٹ بنانا ہے فارمولا لگا کر۔ جس میں باجماعت، انفرادی اور قضاء نمازوں کا گراف دکھے اور ہفتہ ماہانہ حساب لگ سکے۔ اللہ پاک آپ کو اس پہ اجر عطا فرمائے آمین

[@DataSamajh]

Masood aapka idea bohht shaandar hai. Main ispe kaam karloon phir video banata hoon

[@saeedasim8376]

@@DataSamajh ماشاءاللّٰه

[@asgarshaikh7753]

Main b tiktok se hi aya hoon sir lekin vloocup bhool jata hoon aap bahot achha kaam kr rahe he sir

[@DataSamajh]

Shukriya asgar. Tiktok pe sirf tricks sikha sakta hoon. Yahaan pe to full training ho sakti hai.

[@DataSamajh]

Abhi tiktok ban hai to aap meri short videos snack video app pe BHI Dekh sakte hain sck.io/CW91GDBx

[@adnanpathan8548]

Zbrdast mashallah kharal sb

[@DataSamajh]

بہت شکریہ عدنان

[@salmanfaridi9228]

Great Sir I was also finding that how to apply vlookup formula. I saw many videos but I cannot understand the way. Your way of explaining is great. Now i can easily apply the formula. Thank you sir.

[@DataSamajh]

This is what I felt when i explored Vlookup very first time. Keep spreading the knowledge. And do circulate in your WhatsApp groups.

[@jahanzaibali590]

sir ap mere Guru ho thank you sir G

[@DataSamajh]

Izzat afzai ka shukriya

[@khubaibyasin5617]

great mashallah

[@DataSamajh]

Good to know

[@syedarifhilal7048]

The way of your teaching is an Amazing

[@DataSamajh]

Thanks Arif for praise

[@rashidnaveed2110]

Nice explanation,thanks.❤

[@DataSamajh]

My pleasure

[@nasirjamilmalik4468]

Yeah most useful formula hai excel ka.

[@DataSamajh]

Bilkul

[@ArshadAli-ph9zt]

Sir I like your teaching methods keep it up .

[@DataSamajh]

Thank you so much Arshad

[@knowledgevillage8139]

sir jazak Allah for this

[@DataSamajh]

Ameen

[@abidbashir3531]

Nice explanation,very easy way to understand VLOOKUP,JazakAllah

[@ahmadfaridnaeemi4642]

Jazak ALLAH Sir

[@DataSamajh]

Ameen

[@farmsandtractorshouse3093]

Excellent sir

[@DataSamajh]

Good aapko pasand aya

[@tjsthejunglestory9896]

Izzat bacha li sir ap ne thank you so muchi

[@DataSamajh]

Hahaha chalo great ho Gaya!

[@faisalsattar9939]

great sir

[@DataSamajh]

Thanks

[@siyarullah2944]

Thank you so much Sir

[@abdullahnazir215]

Good work ✨

[@DataSamajh]

Thanks

[@kashirhussain622]

JazakAllah

[@DataSamajh]

👍

[@Iconinside]

Thank you sir

[@jafarhussain2108]

Superb sir . Nice explanation and I understood clearly know what is vlookup. Many thanks.

[@DataSamajh]

Mujhe khushi hui Jafar

[@shiatube9372]

Assalam o alikum, did not find second video of vlookup. Please share the link. I use this method but not succesful. Want to do in 2 sheets.

[@Sadyasad]

Superb sir nicely simply explaination❤️

[@DataSamajh]

Bohht shukriya Asad aapko content Pasand Aaya

[@asifshahzad95]

dear sir please 2 excel shet k data ko comapre kr k same value find krny ka tareka bata den

[@uzair8727]

Columns hide kiye hon ausko bhi count krengy ???

[@Maqbooljani444]

Sir mesal k tor py mere pas Jan01. Sheet ha. Ab next year me jab Jan01 sheet bnaon to wo excel kahta ha name chang karo. Eska hal bata dain plz.....

[@lightoftheway1819]

Good sir🌹🌹💐👍

[@DataSamajh]

Thanks Navid

[@ghulamnabiimran8985]

nice sir

[@DataSamajh]

Thanks

[@badbloodxd]

Sir 2 sheets pe vlookup kese lage ga? wp formula laga k batayen kindly

[@mohsinbalochtech]

Sir green screen use krty hn???kindly editing tutiorl bhi dn

[@DataSamajh]

Jee main green screen use karta hoon. Ye Camtasia software se

[@DataSamajh]

Beshak aesa hi hai. Bohht se kaam ho Sakte hain

[@mohsinbalochtech]

@@DataSamajh Sir kindly aik lecture us py dain...

[@malikmujahid3796]

Sir igr hum excel mn urdu sheet bnai hy mean urdu mn store ka data lkha hwa hy wahn vlookup ka formula ksy use kry gy Ya to English mn hy urdu ka b bta dy shukriya

[@DataSamajh]

Mera to khayal hai k koi faraq nahi beshak data urdu main likh lo

[@falakfalak3853]

Sir mai ne 2 sheets banae hain excel mai. Os mai first sheet k column mai words hain aur 2nd sheet mai table hy jo k linked hy 1st k sath. 2nd sheet k table mai 3 cell hain jo "special tasks, common tasks aur others" k nam se hain. 1st sheet mai jab mai common ya special task likta hun to 2nd sheet k table mai osy 1 count karty hain lekn "others" mai mery pas 3 cheezen hain jesy "schedule task, unscheduled task and regular tasks" mai chahta hun in 3 words mai se mai 1st sheet mai jo b likon wo 2nd sheet k "others" mai count ho..plz reply

[@DataSamajh]

Aap kindly sample data ke saath apni sheet mujhe send kardo. I will work on it and share the solution

[@falakfalak3853]

@@DataSamajh ok thanks

[@AliRaza-jg7to]

Assalamualaikum, Sir please make a video of stock management on which date the product has arrived, how much has quantity and how much has been used and how much stock is behind.

[@chfahii8457]

Sir hm ak,sheet sa dosri sheet na kasy farmola lga skty ha

[@DataSamajh]

Simple equal to press karke dusri sheet k cell ko click Karo

[@labelstags7462]

Aslam u alikum sir , ma jb f2 press kar ka formula copy karta hon address ma se or country waly column ma paste karta hon to address ma country wala cell number show hota ha , or address or country ma same result ata ha, pls guide me

[@islamiclibrary1926]

Asalam-o-Alaikum sir mujhy aap sy kuch guidelines chaheyain inventory management k hawalay sy excel ke madad sy. Ek Pro lun ye h mere pas multiple units of measurement hain or mujhy data filter krty howay apni asal hadaf tk poanchna hain so plz sir help me.

[@worldexploretv5883]

Jesy ap n uper parts mention keye hn esy he continues mention krty jy

[@DataSamajh]

Acha karta hoon

[@worldexploretv5883]

Saleem bhai full course update kry na jis n sekhna he us n sekh he jana he he ap n just 2 vdeo dali he ap apna kam krty jay kamyabi ap ko jald maly gi Allah kry

[@DataSamajh]

Bus chalta ja Raha hai

[@pakmedia9100]

Asslam o Alaikum, sir developer, Help, Acrobat, Power pivot, Quick books, ko show kasy kurty han hum, guide me tool bar pur

[@DataSamajh]

Ye customise ribbon se ho sakta hai

[@allauddinmalik7043]

Sir please ik cheez clear kar dy jb mai vlook formula laga raha hn to mai id num found karna chata hn to formula theek lagjata hai lakin wo id num ki jaga 7.84+14 ka error dy deta hai please help

[@DataSamajh]

Is cell Ka format text ya general kardo

[@aliabid9133]

SIR AP NE FORMULAY KO LAST ME F2 PEHLY PRESS KIA YA BAD ME ME SLECT KR KRHA HON LEKIN PASTE NHI HO RHA

[@DataSamajh]

Match ka formula column number ki jaga paste kia hai

[@ArshadAli-ph9zt]

Sir automatic Students results cards pictures ko automatic lane Ka trika btaen den plz. Mene pehle b Ap se 2 dafa questions puche the magr Ap be reply ni Kia kindly is bar zroor kijye GA

[@DataSamajh]

Arshad sb insha'Allah ispe bhi koi nai video banaoo ga

[@ArshadAli-ph9zt]

@@DataSamajh Thanks to reply me sir, Vlookup k zrye Baki data to ajata he mgr sirf pics change ni Hoti kindly kindly ineed ur help for this.

[@waqarahmad1651]

Sir kia hum sari Column ek bar he he ni select kr sakty? Thanks

[@DataSamajh]

Haan headings ke korner ko press karke

[@shahabkhan2891]

Hello, is there any way i can contact you directly? I have a file that need your attention and i want some help to understand the solution..

[@DataSamajh]

[e-mail]

[@spotlight198]

sir parmacy ka aik tabe banao excel main

[@DataSamajh]

Kya kya information Hoti hai?

[@bilalqamar2120]

Aslam o alaikum Sir. Formatting of look up value should be same or different format can work throug vlookup??

[@DataSamajh]

Bilal thanks for asking. Formatting se faraq Nahi parta. Cell ke contents same hone Chahiye

[@bilalqamar2120]

Thank you so much for replying. Or text ko lookup kr skta ha formula ya nhi?? Please answer

[@CreativethinksbymrBugs]

اسلام علیکم سر امید ہے آپ خیریت سے ہوں گے😘 سر مجھے سمجھ نہیں آ رہی کے میں آپکا شکریہ کس طرح ادا کروں کیوں کہ میں اکیڈمی میں فیس دے کر بھی اتنا نالج حاصل نہیں کیا جتنا آپکی وڈیوز دیکھ کر کیا شکریہ سر اللہ پاک آپکو ہمیشہ خوش رکھے اور آپکا سایہ ہم پر سلامت رکھے تا کے ہم آپ سے کچھ سیکھ سکیں (آمین)😘😘

[@DataSamajh]

بس اکیڈمی والے زیادہ تر نوٹ چھاپنے کے چکر میں ہوتے ہیں۔ میں نے بھی جوانی میں بہت پیسہ خرچ کیا۔ مجھے خوشی ہے کہ آپ سیکھ رہے ہو

[@tasadduqmajeed68]

Brother Proportional value entry ka Kia formula ho ga?

[@DataSamajh]

Please explain

[@waseembaber7739]

How we fix salary by designation mtlb cell may hlp ky agy 20k aur opt ky agy 21k a jye

[@habiburrehman4400]

sir ge hum yah exel , word or PowerPoint kha sy download krain without trail

[@asadnawaz1574]

Very Nice.. Abi please ake video or upload krin jis ma hamara data sheet 1 pay ho. Or results sheet 2 pay ho.

[@DataSamajh]

Thanks Asad insha'Allah plan karta hoon ispe bhi

[@Shoaibvlogs7]

Nice sir ma vlookup farmola use krta ho muja bilkul taf ni lagta

[@DataSamajh]

Sun Ke bohht Acha laga. Keep learning

[@sajidahmed2526]

AOA mujhay aisay formula ki talash hay jis Kay Zariay daily Kitnay items ki fitness check kar saktay hain if items are 74 and days 30 weekend ko nikal kar thanx

[@sajidahmed2526]

Only just on Change of month

[@DataSamajh]

Koi example bataein. Mujhe zayada samajh nahi aai

[@ahmadshah2290]

Sir plz pivotTable k bary mn bta dn

[@DataSamajh]

Ye video dekho kzbin.info/www/bejne/gIbWd6Sbq7qZrK8

[@RashidRahi]

Sir ek salary sheet ki bhi video banay jis ma present absent half day working days per day salary bonuses advance deductions or fines and next cash in hand means total slaary

[@fayyazbahrain]

Asalamu alaikum brother, i would like to ask if we want to search company name next to country cell then hiw we will lookup, i mean on the left side column how we can search

[@DataSamajh]

That is not easily possible with Vlookup

[@SajjadAli-nx6hj]

Jis main auto broker ki commission calculate ho

[@ibrarahmadshadswati4082]

Sir please make one video for stock of sale rvc final & stock less then 1

[@DataSamajh]

Is main kya kya elements rakhte ho, aur kya kya calculations karte ho?

[@ibrarahmadshadswati4082]

@@DataSamajh sir who articles jo zero hogy wo pir b stocks sheet may hoo waho kase hide Karan hia please

[@DataSamajh]

@@ibrarahmadshadswati4082 kya aap apni stock sheet mujhe send kar sakte hain [e-mail] kyunke mujhe aapki baat is tarah samajh nahi aaeygi

[@ibrarahmadshadswati4082]

@@DataSamajh sir email correct nahi hia

[@DataSamajh]

spelling check karo [e-mail]

[@saaimsyed5593]

And please inform can you explain macros also...

[@aleenayezaa336]

Sir please make playlist of tiktok videos. And upload all tiktok short videos here. I have liked your videos to watch later but now its banned. So please upload here

[@DataSamajh]

Mujhe sab se zyada afsos hua hai. But don't worry. Meri short videos snack video app pe BHI Hain sck.io/0As5i9uP

[@aleenayezaa336]

@@DataSamajh thank you for your reply, now I will download snack app just because of your videos.

[@g-watchzone7422]

How we can lookup the image from one sheet to another sheet through model number

[@DataSamajh]

Don't know. Will explore

[@mohibafridi9070]

Kindly 1 class on conditional formatting

[@DataSamajh]

insha'Allah

[@sherhamza607]

Bhaie ap ko ma na masage request Kya tha

[@RashidAli-ql7xo]

I want to add timing to my team. Tell me how to calculate

[@zahidkhan-km5gm]

Voucher main amount ko words main b ana chahiye tw kia Karna chahiye

[@DataSamajh]

Zahid VB coding se ye possible hai. Lekin koi formula Nahi hai iska

[@zahidkhan-km5gm]

@@DataSamajh iska b koi video bnado

[@DataSamajh]

Ok

[@javedakhter7916]

Sir auto serial number and auto date entry ka formula tain

[@dailyjobsads939]

Sir beginning se shoro karo sara excel ham ap se easily seek rehe hai

[@DataSamajh]

Meri videos pasand karne ka bohht shukriya. Maine zero se hi start kia hai jesay meri playlist"zero se Hero" bilkul naey logo ke liye hai

[@dailyjobsads939]

@@DataSamajh sir ap se main easily seekh raha ho .....har interview me pehly hamse excel k bary me pochty hai

[@DataSamajh]

Haan kyunke ye Bohht important software hai

[@numanakbar5041]

Teach us pivot table

[@DataSamajh]

Bhai pehle mere channel ko to dekh lo kzbin.info/aero/PLIPEa-zKkIK4Bz_sNBa4IlwGndBcCVgW2

[@khanasif3017]

AI in Excel use

[@DataSamajh]

Yes it is

[@MuhammadBilal-cm6ub]

dear sir i need your help. im working in HR department or company main total 3300 employees kam karte han or ma nay excle ma sheet banani hay sir main sirf employee ka jasy factory card number inter karo or employee ka baqi data jasy name father name date of joining department designation ye sub automatically aa jay

[@DataSamajh]

Ye easily ho jaega. Wait for my next video

[@allauddinmalik7043]

Mainy aj VLook Formula sy ya cheez banai hai mery pas 5000 manpower hai just id num likha sara data aa gya

[@SajjadAli-nx6hj]

Sir mujy trading sheet bana dy

[@DataSamajh]

Acha aap shares main trade karte ho?

[@SajjadAli-nx6hj]

@@DataSamajh g trade kerta ho

[@SajjadAli-nx6hj]

@@DataSamajh thanks for replay

[@SajjadAli-nx6hj]

@@DataSamajh kab tak ap bara dy gy

[@SajjadAli-nx6hj]

Plz

[@DataSamajh]

جی سجاد

[@saaimsyed5593]

A good effort but left so many things. First of all you should have mentioned HLOOKUP also, secondly you did not tell why VLOOKUP is necessary and what link does it have with IF formula, thirdly you linked it up with search purpose only...

[@DataSamajh]

Thanks for your suggestions. Hope to hear from you more. And no doubt this was just one video

[@bossmemon7542]

This is not a helpful because y r searching on same sheet please teach from other sheet

[@DataSamajh]

Memon bhai this works exactly same if you refer to data from other sheet

[@MUsman-lb8nl]

Thank you sir 🎉.