Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel
Вставка
- Опубліковано 30 лис 2020
- Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel
1. Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel
2. Use Vlookup and Indirect to find the 2nd Match with helper column
3. Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel without helper column
Excel Lookup Function Playlist Link - • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#innozant #excelchart #chartandinfographics #exceldynamiccharts
dil se sir apke jaisa UA-cam par nahi hai excel padhane wale
Thanks dear ..keep learning
When the notification blinks, I just feel my favourite Sir is taking me one step forward towards the success.
I can't explain sir, how much your lessons help the students like me.
Great Inspiration.
Love you and truly I feel awesome with this commnent.. Thanks for showny this much love and support.♥️🙏👍
Great teacher
This is beyond excellent sir u r a rare gem in advance excel lot's of things I have learnt from you lots of love to you sir god bless you.😊❤
Your way to teach is ULTIMATE. It helped me the most when required. Please also start VBA series as it the most important and useful part of automating the tasks in this era.
Thanks Ramandeep Ji..Happy Learning dear...Yes I am planming to start Video series.
@@Innozant Thanks for the update and great to see your reply within 24 hours of comment. Only dedicated & focused people can do this. WISH YOU ALL THE VERY BEST!
maja aa gaya bhai, chahe kuchh bhi samaj aaye, na aaye lakin speech badhiya hai 👌
Hahahaha....samajh me bhi aayega dear.
Sequence me Seekhiye concept ko.
Random video nhi dekhiye , playlist start se end Tak dekhen
U r such a hardworking teacher...salute ur efforts..excellent explanation sirji
Thanks Ramakant Ji for such a wonderful and valuable feedback . Really Means a lot to me dear.❤️🙏👍
Very helpful
Am from Pakistan but I love innozant channel ❤
Very happy to see you and also happy learning with you
Thanks Amit ji for this valuable feedback ♥️♥️🙏👍
Thank you
ये तो बहुत ही गजब Formula सिखाया सर आपने
Thank you
Thanks dear
Very interesting and helpfulness
I WATCHED YOUR EXCEL VIDEO VERY GOOD AND EFFECTIVE
Thank you so much sir🙏
Kuch din pahle se aapke video dekha start kiya hai aapke jo samjhane k tarike h o kafi achhe hain🙏
Thanks dear.. Happy learning ❤️
Aapki classes dekh k lgta h ki main interviewer ko kuch naya sikha dunga..
Just kidding. Top content brother. 😄
Haha..ye aap majak nhi sach keh re ho..aap complete series cover kriye..interview questions practice kijiye..ye baat apki sachme sach hogi.. m sure.😀
@@Innozant No doubt bhai. Bas series complete hi hone wali h. Fir MIS interview series dekta hu..
Thanku for the video sir great explaination. good night 😴😴
Thanks Satish Ji.♥️🙏👍gn
very excellent sir
Very useful thank u sir
Thanks Vishal ji❤️
Hi sir, you r explaining all formulas very enthusiastically,👍 i want to learn vba macros basic to advance level from you... If any videos made by you please share link
...
🙏♥️👍 Thanks dear.VBA series not started yet ,After finishing excel will start Power Series-Power Query ,Power Pivot ,Power BI followed by VBA and other associated technologies.Have patience ..🙂🙏♥️
Excellent sir 👍👍👌
🙏❤️👍
Thank a lot sir
Thanks Rajeev ji
Great Logic
Thanks 👍🙏❤️
Sir you are such a fabulous teacher. Everyone can explain but your method of teaching & explaining is best & better. A child can easily catch. Thanks for your great effort...
Sir can you please explain how to find 3 & 4 Product as well. & one more thing before Match function and after & you add bracket "(" why?? I think its for Indirect but if you will explain its better.. Thanks.
Thanks Jinesh for your valuable appreciation..You mah do the same process foe 3rd or 4th value by increasing match as formula element value.
Nice sir
loved it
Thanks Ubaidillah Sahab ❤️🙏
Superb....
Thanks Mishra Ji for your valuable feedback. Happy Learning ❤️🙏
Gjb sir Ji 🙏🙏
Thanks ❤️👍🙏
Woow sir concept is alag hai thanks for taking my name is table 🙏🙏
Thanks Abhishek Ji ❤️🙏👍
Nice video sir!Just now I realised my name is on the screen.:)
Thanks Mira❤️❤️👍👍God bless you dear
Sir aapnai aaj new concept shikhaya. Aapsai acha teacher koi nahi. You are very unique. Your teaching so different. Aapkai teaching ka bahut hi acha style hai. Har step ko achai sai decribe kartai ho aap. Kaha par kya hoga. Thank you so much sir 🌠🌠🌠🌠🌠🌷
Thanks Sandeep itna mere mehnat ko appreciate Karne ke liye.God bless you dear♥️🙏👍
❤️❤️❤️❤️
🔥🔥🔥🔥
🙏❤️♥️👍
Sir, First of all I am very thankful to you. I would like to say this I applied the formula for Second Match but if I have the data in which I want the first match in a cell and then Second Match in succeeding cell and third match in further succeeding cell and so on....then what would be the formula or Logic.
Customer Name Deeksha Aggarwal
Lemons
Apples
Strabery
.....So On
❤️🙏🙏🙏👌👌⭐⭐⭐⭐⭐
🙏❤️👍
Sir, please bring VBA series soon as it is frequently asked in interviews..
Yes Param,We are planning to start the same
Superb
Thanks dear
Guru gi kindly advise if the number in the a 1:a15 column are same I need to pull out the highest value in the b1:b15 columns please advise
Hello sir, Actually i have to apply same formula for mulitple columns is it possible ??
Index(columnb,small(if(columna=given value,row(a)-row(a)+1),rows($a:a)))
Since here we need the second value we can type 2 instead of the rows function.
⭐⭐⭐⭐⭐
🙏❤️👍
Sir I want to learn excel from you. From Very basic. I have also done advance excel course but I could not understand anything. Please tell me what should I do to learn from you. I want to become a data analyst. please give proper guidance.
jatadhari ji , i did ,to find n number of duplicates without helper coloumns
Sir but if the lookup value is repeating more than twice, then to find the 3rd order and so on, this formula won't work! 😔
🙏🙏🙏🙏🙏🙏☺️☺️☺️☺️☺️☺️
Humko +2 kar k skip nhe karna, large data set pe to ye solution applicable hi nhe hoga, agar deeksha agarwal 4 times ajaye start mn hi, to kia +3, +4 karte rahenge formula mn??
Bina +sign k batayen.
😘😘
Thanks Ajay Ji♥️🙏👍
Bhai may jab apka helper column wala procedure apply krta hoon result NA ata hy?aap help krdygy
ok 2nd product ke liye indirect chalaye, multiple product ke liye tho phir HELPER kohi lena padegana.aur detail me multiple products, and huge number of customers mamually tho nahi kar sakte. customers and products automatically identify kiss farmula se karna plz. batao.
What if we need to extract third, fourth... Value in vlookup
sir kia ham is ko power query kaay sath ker saktay haay ,,,kis tarah
SIR THIS CONSEPT EXTRACT MAX TO MAX 2 RECORDS HU WHAT IS THE EXTRACT MORE ATHAN RECROEDS
But If motive was to skip first two row, why not simply use OFFSET??
Sir please make video on how we can use symbols in formula like ..&, () , etc ..
Already explained in no. Of videos dear..kindly learn step by step
Sir
Agar lookup value ke many match ho to sabhi match nikal sakte h dusri sheet par without helper column
Haan kyu nhi .. vlookup ke saaty indirect uae karke nikaliye..
@@Innozant sir Thanks for your reply lekin jaise man lete hai field ki employees ke expense report bana rakhi employee code wise, usme se ek code ki sabhi entry nikalni h vlookup se
Like filter ki tarah lekin vlookup se
"Yahin se yahin tak mei usi ko" waala concept ko thada detail mei samjha dijiye sir !
Phirse ek baar dekhiye video
Sir please make vedio on reverse vlookup with choose,and make it dynamic
Reverse vlookup video is already there ❤️🙏
SIR INDIRECT FUNCTION HORIZONTAL KAISE USE KARE THODA BAATAYAEE
HORIZONTAL SUM KAARNE HAIN
Sir mujhe row wise lana hai to kaise karenge..
But sir, in the 2nd mathod,
how can you decide to skip first row "A", this mathod is wrong to get Answers. It could be more down from "A3" then ? What
Sir, Pls help in building formula to find nth value from a repeated list through vlookup and indirect...This video is only applicable upto 2nd look value
What output you want?
@@Innozant 3rd lookup, 4th lukup
Sir,
Column ke time array ki jaigah pe column name ko nehi le kar agar name leta toh kaya formula galat batayega?
Offcourse error btana chaiye column number chaiye hota hai na ap wahan naming range kaise de skte hain?
Sir excel main koi aisa tareeqa ha jis say hum data match kar skay
Examaple
K aik Vichel ha woh
City A 1 apr ko 23:00 bajay aayi
Or or City 2 3 apr ko 10:00 bajy phonchi
Tu mahinay main kitnay trip kiye or
Is vichel ki journey deatil kesay find out ho gi q k vichel ka number nahi balkay us ki date say find out ho or second main Product qty say maloom ho
Kia aisa posibal ha
Sir is formula mein plus 3 karke 3rd order bhi check kar sakte hain? teesra duplicate dhoondne ke liye ? VLOOKUP(F2,INDIRECT("$A$"&(MATCH(F2,$A$2:$A$17,0)+3)&":$B17"),2,0)
Haan range se bahar is value ko rakhke kr skte h
@@Innozant ok sir main ek baar phir try karoonga 😀
I need vlookup with all match
Hi need help in formula
9:29
sir apne yha pe manually +2 kiya match function ke bad.
dynamic to ab bhi nhi hua formula.
agr "diksha aggarwal" 2 se jyada bar repeat ho aur 3rd order ya 4th order...nth order wali "deeksha aggarwal" ka answer chahiye hoto to formula me bar bar match ke bad jo plus krna h uski value change krni hogi manually.
mene iska bhi solution find krne ka try kiya but nhi hora.
agr apko kuch solution mile to plz btana sir.🙏
Ye dynamic nhi vlookup second match Question tha Ishu,Haan nth match bhi Kara sakte hain as per requirement,Aapne kya socha Uske liye btaiye..main help karte hu dynamic bnane me
@@Innozant
mera bs yhi question h ki agr deeksha aggargar 1 se jyada bar repeat ho aur agr 3rd position wali deeksha aggarwal ka output lana ho bina match ke bad kuch manually plus kiye to kese laye.i mean koi data validation se list bnake jisme 1 to nth number tk list ho aur jo number us list se select kre us position wali diksha aggarwal ka output aa jaye to use dynamically kis formula se krenge.formula me manually kuch change nhi krna jese apne video me +2 kiya tha match ke bad.if possible,then please reply🙏
Haan to manually add krne ke jagah Jo data validation list liiya hai Uske liye match Chala lijiye wo us relative position Ka text extract krke le aayega
@@Innozant sir usse bhi nhi ho payega.
mera mtlb ye tha ki ek cell me names hone chahiye jese apne is question me kiya hua h aur uske sath wale cell me only numbers ki list.list bnana jrori nhi h.kisi cell me bs numbers bhi likh skte h.
jese ek cell me deeksha and doosre cell me 1,2 ,3 or nth number.aur vo formula usi number vale position ki deeksha ka output laye.
ye match se possible kese h?🤔match hi lgana h to helper column lena hoga.mujhe bina helper column ka answer chahiye.it's ok sir,i know bhut mushkil h ye.bina helper column ke maybe possible nhi.
Sir index se try kiya 2nd value nahi nikal rahaere se kese hoga? Ek kisi vedio main Bata dena plz🙏 ya yahi bata do aap
Ok..Wil try to add it in videos.
Good but flop because you have given manual figure 2 in between. It is better to select area manually then not required indirect.
Kindly understand the use and benifit of indirect function as I want desired value without going to that sheet or worksheet
Sir akrim kya hota hai
Thanx sir magar agar hamara data sheet ke beech Mai hota to kaise hota sir pls help
Explain kijiye query unable.to understand
@@Innozant sir agar data beech mai se
Matlb h13 se start huva ho aur i 20 pe tak ho....... To kaise hoga. Sir
Duplicate aue Unique ye dono hin bahut dikkat de rahe hai mujhe sir!
लगता है आपकी मुझसे कोई दुश्मनी है आप मुझे अपना दुश्मन समझते है गुरु जी बाकी हम तो आपसे प्यार करते है 🌹🌹🌹🌹🌹❤
Oho..aisi kya galti humse,
1,2,3,4,..... More than vlookup without helper columns =INDEX($A$2:$B$17,SMALL(IF($H2=$A$2:$A$17,ROW($A$2:$A$17)-1,""),I1),2)
Sir. Innozent. At the time of teaching your excel data spread sheet not at zoom level it ahould be zoom so that easily viewers can be understand.
Zoom to rehta hai..ok aur zoom Kar Diya karunga aage se..Juda krta hu zoom to student ke comment aate Hain ki sir mobile me jyada zoom me dekkkat Hoti hai..koi nhi aage se dhyan rakhunga main..than for suggestions ❤️🙂🙏👍
Thanks for prompt respond.
Your tutoriel and teaching is very fine. Stay bless .Regards.
@@Innozant thanks for prompt repond. Teaching style is very fine. Stay bless & take care. Regards.
@@naeemulhassan1426 Thanks Naeemul Sahab..
I didn't get the whole procedure
Query ?
Who is Deeksha Agarwal because mostly example this name show in first
She is one of the student like You Amrita❤️.Keep Learning.Keep Exploring
Ham tusri sheet sath nahi hote ha
What about the third match sir?
Hi Sujatha ,Third match or nth match ke liye Thora sa aap sochiye ki Jo value hum manually pass Kar rhe Hain wahak match use krke ya Kuch aur method se value pass Kar payen to..🙂
Aap rethink krke is formula ko aur update krke mujhe bataiye nhi to vlookup nth value match Ka video bht jald leke hair HOTA hu dear 🙏♥️
@@Innozant I think in place of +2, something has to be done. I will try sir.
Very Good Sujatha.Try it and let me know 👍
Tough hai
Hmm.little bit...but do rehearse
Last mai enter hi nhi mara
Wo Apke liye Chor Diya hai ki ap khudse formula likhenge aur Practice bhi krenge 😀😀❤️❤️🙏🙏👍👍
Why do you put the title of the video in English and then speak some other language in the video. Click baiters...
It's not click bait dear...This channel is for Hindi Audience only .
Sir y table m aapne data validation kyu lgaya h hme isme kya change krna h??
Second match Karna hai dear..aap ek Baar Ques dekhiye