भाई इससे अच्छा =Vlookup(C2,C2:E6,{2,3,4,5,6},False) इसका इस्तेमाल करेंगे ना जिससे सभी मे value एक साथ आ जायेगी।

@SKLearningJunction

8 ай бұрын

Ye video dekho iski bat kar rhe ho aap. kzread.info/dash/bejne/d5qssZaHfJewcrA.html

@aneeshyada

7 ай бұрын

Correct bro

@ajitturan424

Ай бұрын

Nhi aati bhai

@rajgurjar2352

Ай бұрын

​@@ajitturan424Bro aati h formula lagane ke bad ctrl+shift+Enter kro

बहोत बहोत धन्यवाद सर

Excellent

Bhai likes this video I solved my multi colom vloook issue 🙏 a lot ji bhar ke Jio yaar tum🎉🎉 God bless you dost.

@SKLearningJunction

Ай бұрын

Thankyou

Very Helpfull video

Thank you ! It’s informative video

@SKLearningJunction

Жыл бұрын

Thanks, pls subscribe this channel

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html Try this more informative

Very informative.

Thanks bro, I have learn a lot

very informative, thank you so much for uploading this video

@SKLearningJunction

Жыл бұрын

👍🙏

Thank you so much sir

Thanks so much dear Sir for easy and good knowledge really very thanks dear Sir

@SKLearningJunction

Жыл бұрын

👍

Amazing bro ❤

Nice vedio sir 👌🏻👌🏻

@SKLearningJunction

Жыл бұрын

Thanks bro

Thank u sir

Good video

Very helpful

Shandaar

Fantastic very early solve thanku sir

@SKLearningJunction

Жыл бұрын

👍🙏

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Excellent video 😌😌

@shortclips1168

2 жыл бұрын

thanks bro

@SKLearningJunction

2 жыл бұрын

thanks bro

Nice video ❤💯💥

@SKLearningJunction

Жыл бұрын

👍

Good one

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Nice video pls provide training video on entire conditional formatting its urgent

@SKLearningJunction

Жыл бұрын

Please watch videos from this playlist of Conditional Related -kzread.info/head/PLpIpH99tLOxIxrP1KTiff6Wys7xatbH7e

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html try this

Superb ✌️

@SKLearningJunction

Жыл бұрын

🙏

thanks bhai

Any option that we don't need enter column no. Manual

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/YmWVqLmgf9XAhbg.html Watch this tutorial

Nice

@SKLearningJunction

Жыл бұрын

Thanks

please give link for practicing, practice file upload

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html try this practice file also

Nice Bro

@SKLearningJunction

Жыл бұрын

🙏

Waah bhai, dimag bhai dimag. (Sarcasm)

@SKLearningJunction

Ай бұрын

😊

Vlookup+ match Function se 1 time me sabhi data ko utha sakte hai

@SKLearningJunction

5 ай бұрын

Yes bro

Bhai apne to freeze bataya hi ny apne to dollar ka sign lgaya h formule me to uske bare b bta do

@SKLearningJunction

Ай бұрын

Ok

Thanks for this information 😊

ye to 10-12 columns tha toh ho gaya agaar 20-30 se jayada columons hoga toh ? sara din lag jayega count karte karte uske sath time bhi ,aur boss ko kaise apna kam dunga ? simple vlookup ke sath columns formula apply karo na jaldi ho jaye ga .

@SKLearningJunction

Жыл бұрын

Bro. Try this method 👉👉kzread.info/dash/bejne/c4Bru7CppLjLfrg.html Column +vlookup lgane ki jarurat nhi

Hd h mtlb gajab mje le liye bhaishab aapne toh kuch nahi btaya aapne

@SKLearningJunction

Ай бұрын

Ok, aapko kuch nya sikhna hai to ye dekho kzread.info/dash/bejne/m3dr0bODpsWembQ.html

How to compare sheet 1, Column A + Column B value to sheet 2' Column A + Column B value

Its not working on excel 2016.. Can you explain it??

@SKLearningJunction

2 ай бұрын

It will work when you will copy the full formula from formula bar then paste in another column and change index number

Bhai ise accha hota ki aap column no ki jagah coloumn ka formula laga kar drag kar dete to isse kam time lagta

@SKLearningJunction

2 жыл бұрын

Ok bro, but humen aur bhi method aane chahiye. Thanks for your suggetion

@ecomastronaut

Жыл бұрын

@@SKLearningJunction Column formula ki koi video hai apki?

Innozant channel says this type vlookup is wahiyat vlookup and I agree 😐😐

@SKLearningJunction

9 ай бұрын

You can't judge from one video to entire channel watch this then say

@SKLearningJunction

9 ай бұрын

kzread.info/dash/bejne/m3dr0bODpsWembQ.html

ye to 10 c 12 column the to us p no. edit kr diye...bt agr 100 column ho to is tarah se to kafi time jayge aur confusion bi hoga.

@SKLearningJunction

2 ай бұрын

Ye try kro aap kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Hello sir If error use karke vlookup ki video banao sir..❤

@SKLearningJunction

Жыл бұрын

Ok

sir , plz upload pratice file of this video.

@SKLearningJunction

Жыл бұрын

Ok

@rahulprasad9198

Жыл бұрын

@@SKLearningJunction sir please Share the Vlookup+ match video wala practice file.

Bhai paste krne ke baad #NA ku Ara he dusre colum me

@SKLearningJunction

7 ай бұрын

Aap formula ko open kro the poora select kro and copy karke paste kr do

Thanks bro... I have learnt this..

@SKLearningJunction

Жыл бұрын

I think you need to learn this also -

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/aHyMp6OdcaerXbQ.html

It will take more time , we can use vlookup and match formula for multiple coloumn

@SKLearningJunction

Жыл бұрын

What about the index Match kzread.info/dash/bejne/c4Bru7CppLjLfrg.html

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html - watch this tutorial

formula paste kese hoga

@SKLearningJunction

Ай бұрын

Ctrl C then enter and Ctrl V.

Columns formula use ho skta hai idhar

@SKLearningJunction

Жыл бұрын

Yes

Bhai but next colum me NA aara he

@SKLearningJunction

4 ай бұрын

Aap isko proper open karke copy and paste kro

I have one question

@SKLearningJunction

3 ай бұрын

What?

@SKLearningJunction

3 ай бұрын

Yes pls

Bhai match ka formula vlookup me permanent solution hai Aapne 9 coulman me lagaya agar aage hajaro column hai tab aap aise hi karoge kya

@SKLearningJunction

10 ай бұрын

Pls watch this tutorial

@SKLearningJunction

10 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Bhai advance sey banavo and short time sey plan Karo next time s 🔥🔥

@SKLearningJunction

Жыл бұрын

Ok

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html try it

Bhai ye sahi nhi hai isme bar bar index numbers change karna pad rha hai

@SKLearningJunction

Жыл бұрын

I know but Jo Maine is video me kzread.info/dash/bejne/d5qssZaHfJewcrA.html btaya hai isme nhi karna padega

Vlookup not working all sheet , refe

@SKLearningJunction

2 жыл бұрын

it will work, please confirm what is the actual problem

Large Data par yeh formula sahe result nhi de rha hai .

@SKLearningJunction

4 ай бұрын

Try this

@SKLearningJunction

4 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Multipl code ka formula btaye

@SKLearningJunction

4 ай бұрын

Watch this video

@SKLearningJunction

4 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Bhai index number automatically kaise change hoga isi formula me??

@SKLearningJunction

9 ай бұрын

Watch this

@SKLearningJunction

9 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Tricky hai

Not working for me . Only 2 column data received, rest error #REF!

@SKLearningJunction

Жыл бұрын

Sir, try this method

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Bhaiya me bhi ye trick main bhi use karta hoon lekin mera pura kaam nahin ho raha hai

@SKLearningJunction

Жыл бұрын

Kya problem aa rhi hai?

@SKLearningJunction

Жыл бұрын

Vlookup+ Match bhi use kar sakte ho

Ye excel me nji work krta hy

@SKLearningJunction

8 ай бұрын

Kon sa Excel version hai

Very Lengthy Process, Isse bdiya match function lgaalo baar baar mannual kon krega .. AI ka jamana hai sir thoda automate Krna dikhaao bacho ko

@SKLearningJunction

Ай бұрын

Yes you are right but I have uploaded approximately 10 videos on vlookup so request you to watch this video first kzread.info/dash/bejne/m3dr0bODpsWembQ.html You cannot judge everything from a single videos

in this video vlookup process is very lengthy, we can use vlookup with columns vlookup with match

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrCR.html in this very simple

@gautambhandari7249

Жыл бұрын

Absolutely right bro v lookup with column

@pradeepmamgain6059

Жыл бұрын

Well said bro

@pradeepmamgain6059

Жыл бұрын

Pagal banriya hai

Bhai कॉलम number change karte hi NA ka error aata hai😢

@SKLearningJunction

7 ай бұрын

Formula ko F2 se open karna hai then select all copy and paste . Then change Number

Abhi dukhi hu mai... Kuchh samjh nhi aaya jb aayega tb thank you sir likhungi

@SKLearningJunction

8 ай бұрын

Ok

not very help full it will take enough time. we can try some more ways

@SKLearningJunction

2 жыл бұрын

You need to try the xlookup That's good function

Bhayyu is se achha to hum vlookup k sath match use kr lete to ye vdo 3 minute me ho jata.

@SKLearningJunction

2 жыл бұрын

Ok, but you can try the xlookup it's better than vlookup and match kzread.info/dash/bejne/np19lcyqdszNiJc.html

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html - ye try karke dekho

Bhai maine socha kuch nya sikhaoge...par isse accha to Vlookup Match , Index match h ek hi baar main sara fill ho jata h ...aap bhi woh sikho 😂

@SKLearningJunction

9 ай бұрын

Bhai vlookup par 4 to 5 videos Dali hai aap ye try Karo

@SKLearningJunction

9 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

@rahulkashyap35

2 ай бұрын

🤣🤣

Kya naya bata diya

@SKLearningJunction

4 ай бұрын

Bro isme btaya hai naya

@SKLearningJunction

4 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Normal ha

Brother you have to work on your Excel skill. Bar bar index no. Dalkar change krne ki need nai hai. Isko aise kr sakte hai. =Vlookup,table array,{2,3,4,5,6,7,8,9},0) then ctrl+shift and enter. Pura formula khud hi sare rows me lag jayega. Vdo bnate ho to easy or logically cheeze btao jugaad nahi

@SKLearningJunction

11 ай бұрын

Yes that's why I have make this tutorial also

@SKLearningJunction

11 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

It was very basic. I dont know whats new ?

@SKLearningJunction

9 ай бұрын

But I think this is the new for you

@SKLearningJunction

9 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

this is not an multilookup formulla its manual work , you dont know this

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html Watch this video

Ye kya h. Vlookup+columns use kro iske liye.

@SKLearningJunction

Ай бұрын

Yes, you can use Vlookup + Match Function also

Kya Naya bataya ? Bahut lambi formula hai, aur bhi choti formula like columns formula easy and fast.

@SKLearningJunction

2 жыл бұрын

Bhai xlookup try kro Bilkul simple aur asan formula hai kzread.info/dash/bejne/np19lcyqdszNiJc.html

@SKLearningJunction

2 жыл бұрын

Bhai xlookup try kro Bilkul simple aur asan formula hai kzread.info/dash/bejne/np19lcyqdszNiJc.html

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrCR.html ye dekho bahi

This is not working

@SKLearningJunction

8 ай бұрын

Not possible

It's very lengthy process

@SKLearningJunction

10 ай бұрын

Watch this

@SKLearningJunction

10 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Formula thik hai Perfect nahi Koi aisi trik batao jisase ek bar formula use se kai colum ke data find kar paye

@SKLearningJunction

Жыл бұрын

Video already uploaded

Interview me aise karega na bhai, 1 sec me reject karke gaun bhej dega

@SKLearningJunction

Жыл бұрын

Isliye to Maine ye video bnai Hain

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Agar 1500 columns ho toh pura din baithkar yahi krte rahe

@SKLearningJunction

11 ай бұрын

No ye method try kro one time ho jayega

@SKLearningJunction

11 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

lol

I came here to check how to use vlookup in multiple columns but this man just use a normal vlookup formula.........just wasted

@SKLearningJunction

Жыл бұрын

Try this man,you will shock

Itni mehnat hi karni hoti to trick kyu dhundhta😑

@SKLearningJunction

Жыл бұрын

Pls try this one

@SKLearningJunction

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

😂😂

🤣🤣🤣

Itna galat information q dete ho bhai, agar 500 column data hoga tab sab m krte rhe ge kya bhai KZread se videos dekh k videos banate ho kya Kuch v

@SKLearningJunction

2 ай бұрын

Brother ye bhi alg tarika hai Long data ye method Follow kro

@SKLearningJunction

2 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

@shubhamsinha8584

2 ай бұрын

Sorry ! Thank you ❤

Abe bhai kyu time brbad kiya ,ek bar me bata ye to manually ho gya ..Ye to sabko pata he

@SKLearningJunction

10 ай бұрын

Ye try kro

@SKLearningJunction

10 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

It's very lengthy process. I can fill full shit in one vlookup formula

@SKLearningJunction

10 ай бұрын

Yes I know pls try this

@SKLearningJunction

10 ай бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html

क्या यार क्यों समय बर्बाद कर रहे हो। मैच के साथ volookup लगा लो

@SKLearningJunction

22 күн бұрын

Yes you are right but bahut logo difficultly hoti vlookup ke sath Match apply krne me I have also make videos on this

O Chacha ye bacho ka khel na khilao, ye sabko aata hai, single single jaa rahe ho bhaisaab aise to koi bhi kar le

@SKLearningJunction

2 ай бұрын

Ok

@SKLearningJunction

2 ай бұрын

Ye bhi ek Alag tarika hai Jo sabko nhi pta

@SKLearningJunction

2 ай бұрын

Ye try kro aap kzread.info/dash/bejne/d5qssZaHfJewcrA.html

Pgl he h jb nhi aata toh bta he kyu h itna kon krega

@SKLearningJunction

4 ай бұрын

A bhi ek alag method hai

Bakwas its very simple way isse badia columns ka use kar lo vlookup ke saath

@SKLearningJunction

5 ай бұрын

To kr lo na kisne roka hai

@SKLearningJunction

5 ай бұрын

Ye tumhare liye bakwas hoga but jnko nhi pta unke liye bahut hi sahi trick hai

@DesiKalakarmaal

5 ай бұрын

Abe phle Tameez Sikh le fir Sikhayio Excel Shakal se waise hi harami lagta hai ghanta kuch aata nhi Chala hai Sikhane phle Explained karna to sikh le @@SKLearningJunction

Bakwas. Pehly khud sekh le bhai ayse nhe hota Vlookup. For example if we choose wrong number, then how we will find the issue?

@SKLearningJunction

9 ай бұрын

Mr. I have uploaded to 9 videos on vlookup watch that then say this type of bad words

Bahut bada Gyan Diya Sara Time kharab kar Diya😡

@SKLearningJunction

4 ай бұрын

Bhai kaki video dekh lo phle for bolna

not a good teacher speed boht h bhai apki. aram se samjao

@SKLearningJunction

2 жыл бұрын

Sorry bro.. From the next video I will do Baki videos men achhe se samjhaya hai

@SurajKumar-qe4wb

Жыл бұрын

kzread.info/dash/bejne/d5qssZaHfJewcrA.html - isko try kro

Bhai video dalni band kar do Class 6th ki cheej mat sikhao Match ka formula lagana seekh lo Maine dislike Kiya hai Kyoki meri ⁷ minutes kharab kar di hai

@SKLearningJunction

10 ай бұрын

Ek video me kisi ko judge nhi karte. Ye video bahut time phle Dali thi vlookup ki playlist dekhlo ek bar aapko bahut sari videos milegi jiske bare shayad hi aapko aata hoga

@SKLearningJunction

10 ай бұрын

kzread.info/dash/bejne/aHyMp6OdcaerXbQ.html