Vlookup Second Match | Use Vlookup and Indirect to find the 2nd Match or nth match in Excel

Подписаться 149 тыс.

Просмотров 49 тыс.

50% 1

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

Опубликовано:

30 ноя 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 144

@SanjayKumar-uw9kn 3 года назад

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.

@Innozant 3 года назад

Love you and truly I feel awesome with this commnent.. Thanks for showny this much love and support.♥️🙏👍

@ankitmehta9996 11 месяцев назад

dil se sir apke jaisa RU-vid par nahi hai excel padhane wale

@Innozant 11 месяцев назад

Thanks dear ..keep learning

@souvikdas9110 4 месяца назад

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.😊❤

@muhammedjan9463 2 месяца назад

Am from Pakistan but I love innozant channel ❤

@rajeshrathod2666 Год назад

maja aa gaya bhai, chahe kuchh bhi samaj aaye, na aaye lakin speech badhiya hai 👌

@Innozant Год назад

Hahahaha....samajh me bhi aayega dear. Sequence me Seekhiye concept ko. Random video nhi dekhiye , playlist start se end Tak dekhen

@ramandeepsingh8110 2 года назад

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.

@Innozant 2 года назад

Thanks Ramandeep Ji..Happy Learning dear...Yes I am planming to start Video series.

@ramandeepsingh8110 2 года назад

@@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!

@ramakantwagh7634 3 года назад

U r such a hardworking teacher...salute ur efforts..excellent explanation sirji

@Innozant 3 года назад

Thanks Ramakant Ji for such a wonderful and valuable feedback . Really Means a lot to me dear.❤️🙏👍

@ankurghosh7734 Год назад

I WATCHED YOUR EXCEL VIDEO VERY GOOD AND EFFECTIVE

@bhupendrabisunke2287 Год назад

Very interesting and helpfulness

@khanmbabar 4 месяца назад

Very helpful

@shrikantbadge3978 Год назад

ये तो बहुत ही गजब Formula सिखाया सर आपने Thank you

@Innozant Год назад

Thanks dear

@dirghangiamit9997 3 года назад

Very happy to see you and also happy learning with you

@Innozant 3 года назад

Thanks Amit ji for this valuable feedback ♥️♥️🙏👍

@abhishekjadli1566 3 года назад

Aapki classes dekh k lgta h ki main interviewer ko kuch naya sikha dunga.. Just kidding. Top content brother. 😄

@Innozant 3 года назад

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.😀

@abhishekjadli1566 3 года назад

@@Innozant No doubt bhai. Bas series complete hi hone wali h. Fir MIS interview series dekta hu..

@subhashsonu6842 Год назад

Thank you so much sir🙏

@solotravellerAmit 2 года назад

Kuch din pahle se aapke video dekha start kiya hai aapke jo samjhane k tarike h o kafi achhe hain🙏

@Innozant 2 года назад

Thanks dear.. Happy learning ❤️

@satishojha6240 3 года назад

Thanku for the video sir great explaination. good night 😴😴

@Innozant 3 года назад

Thanks Satish Ji.♥️🙏👍gn

@khanmbabar 4 месяца назад

Thank you

@dudeyme3331 2 года назад

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

@jineshdas6423 3 года назад

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.

@Innozant 3 года назад

Thanks Jinesh for your valuable appreciation..You mah do the same process foe 3rd or 4th value by increasing match as formula element value.

@nileshchavan742 3 года назад

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 ...

@Innozant 3 года назад

🙏♥️👍 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 ..🙂🙏♥️

@kinghundred 3 года назад

very excellent sir

@AkashYadav-df6nj Год назад

Hello sir, Actually i have to apply same formula for mulitple columns is it possible ??

@sandeepaswal8944 3 года назад

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 🌠🌠🌠🌠🌠🌷

@Innozant 3 года назад

Thanks Sandeep itna mere mehnat ko appreciate Karne ke liye.God bless you dear♥️🙏👍

@AzharKhan-kd9bf Год назад

Bhai may jab apka helper column wala procedure apply krta hoon result NA ata hy?aap help krdygy

@bhupendrasolanki2243 Год назад

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

@abirsarkar7075 2 года назад

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.

@rashidkhan8467 8 месяцев назад

Nice sir

@vishalbhati912 2 года назад

Very useful thank u sir

@Innozant 2 года назад

Thanks Vishal ji❤️

@crazy2us 2 года назад

SIR THIS CONSEPT EXTRACT MAX TO MAX 2 RECORDS HU WHAT IS THE EXTRACT MORE ATHAN RECROEDS

@shakeibfaridy1522 6 месяцев назад

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.

@TheVaibhav1982 2 года назад

What if we need to extract third, fourth... Value in vlookup

@user-rr1xs3hf6f 10 месяцев назад

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.

@rjraviraftarup7553 3 года назад

Excellent sir 👍👍👌

@Innozant 3 года назад

🙏❤️👍

@abhishekshirsekar2065 3 года назад

Woow sir concept is alag hai thanks for taking my name is table 🙏🙏

@Innozant 3 года назад

Thanks Abhishek Ji ❤️🙏👍

@khalidmajeed2886 Год назад

sir kia ham is ko power query kaay sath ker saktay haay ,,,kis tarah

@rajeevvyas4854 2 года назад

Thank a lot sir

@Innozant 2 года назад

Thanks Rajeev ji

@bhimbiswakarma475 Месяц назад

Sir mujhe row wise lana hai to kaise karenge..

@jaleel2477 10 месяцев назад

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.

@ExcelGuru Месяц назад

jatadhari ji , i did ,to find n number of duplicates without helper coloumns

@rajdeepsaha9059 3 года назад

Great Logic

@Innozant 3 года назад

Thanks 👍🙏❤️

@virendrahardiya2797 Год назад

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

@balamira297 2 года назад

Nice video sir!Just now I realised my name is on the screen.:)

@Innozant 2 года назад

Thanks Mira❤️❤️👍👍God bless you dear

@paramgandhi6361 2 года назад

Sir, please bring VBA series soon as it is frequently asked in interviews..

@Innozant 2 года назад

Yes Param,We are planning to start the same

@gjsanu 2 года назад

But If motive was to skip first two row, why not simply use OFFSET??

@meriawaazhindi5217 Год назад

❤️❤️❤️❤️

@ubaidillahmuhammad20 3 года назад

loved it

@Innozant 3 года назад

Thanks Ubaidillah Sahab ❤️🙏

@roshanimishra5850 3 года назад

Superb....

@Innozant 3 года назад

Thanks Mishra Ji for your valuable feedback. Happy Learning ❤️🙏

@hsgusain2054 3 года назад

Gjb sir Ji 🙏🙏

@Innozant 3 года назад

Thanks ❤️👍🙏

@ankurghosh7734 Год назад

SIR INDIRECT FUNCTION HORIZONTAL KAISE USE KARE THODA BAATAYAEE HORIZONTAL SUM KAARNE HAIN

@SachinSharma-lh8cq 3 года назад

Sir Agar lookup value ke many match ho to sabhi match nikal sakte h dusri sheet par without helper column

@Innozant 3 года назад

Haan kyu nhi .. vlookup ke saaty indirect uae karke nikaliye..

@SachinSharma-lh8cq 3 года назад

@@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

@sardarbilal021 Год назад

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

@pritamdey4556 2 года назад

Sir, Column ke time array ki jaigah pe column name ko nehi le kar agar name leta toh kaya formula galat batayega?

@Innozant 2 года назад

Offcourse error btana chaiye column number chaiye hota hai na ap wahan naming range kaise de skte hain?

@rjraviraftarup7553 3 года назад

❤️🙏🙏🙏👌👌⭐⭐⭐⭐⭐

@Innozant 3 года назад

🙏❤️👍

@devendradavande5369 2 года назад

Sir please make video on how we can use symbols in formula like ..&, () , etc ..

@Innozant 2 года назад

Already explained in no. Of videos dear..kindly learn step by step

@MrRashmimallick 2 года назад

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

@Innozant 2 года назад

What output you want?

@sirireddya Год назад

@@Innozant 3rd lookup, 4th lukup

@rjraviraftarup7553 3 года назад

⭐⭐⭐⭐⭐

@Innozant 3 года назад

🙏❤️👍

@surajsinghrajput9321 3 года назад

🔥🔥🔥🔥

@Innozant 3 года назад

🙏❤️♥️👍

@awanishanurag1763 Год назад

"Yahin se yahin tak mei usi ko" waala concept ko thada detail mei samjha dijiye sir !

@Innozant Год назад

Phirse ek baar dekhiye video

@avanishchandra3795 3 года назад

Sir please make vedio on reverse vlookup with choose,and make it dynamic

@Innozant 3 года назад

Reverse vlookup video is already there ❤️🙏

@horrorlovestories 2 года назад

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)

@Innozant 2 года назад

Haan range se bahar is value ko rakhke kr skte h

@horrorlovestories 2 года назад

@@Innozant ok sir main ek baar phir try karoonga 😀

@awanishanurag1763 8 месяцев назад

Duplicate aue Unique ye dono hin bahut dikkat de rahe hai mujhe sir!

@deepaksharma-sg3uo Год назад

Hi need help in formula

@Marathiboost 3 года назад

Superb

@Innozant 3 года назад

Thanks dear

@Unfiltered_ind 2 года назад

Sir akrim kya hota hai

@shankarthakuri7145 Год назад

I need vlookup with all match

@gauravbhatia7987 3 года назад

🙏🙏🙏🙏🙏🙏☺️☺️☺️☺️☺️☺️

@puransingh-sx2tk 3 года назад

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

@Innozant 3 года назад

Ok..Wil try to add it in videos.

@ishutiwari5567 3 года назад

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.🙏

@Innozant 3 года назад

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

@ishutiwari5567 3 года назад

@@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🙏

@Innozant 3 года назад

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

@ishutiwari5567 3 года назад

@@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.

@ajaysaroha2539 3 года назад

😘😘

@Innozant 3 года назад

Thanks Ajay Ji♥️🙏👍

@sethushankaranmadhavanmadh6712 Год назад

Good but flop because you have given manual figure 2 in between. It is better to select area manually then not required indirect.

@Innozant Год назад

Kindly understand the use and benifit of indirect function as I want desired value without going to that sheet or worksheet

@paramjeet975singh3 2 года назад

Thanx sir magar agar hamara data sheet ke beech Mai hota to kaise hota sir pls help

@Innozant 2 года назад

Explain kijiye query unable.to understand

@paramjeet975singh3 2 года назад

@@Innozant sir agar data beech mai se Matlb h13 se start huva ho aur i 20 pe tak ho....... To kaise hoga. Sir

@shahnajmitu3284 2 года назад

Ham tusri sheet sath nahi hote ha

@naeemulhassan1426 3 года назад

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.

@Innozant 3 года назад

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 ❤️🙂🙏👍

@naeemulhassan1426 3 года назад

Thanks for prompt respond. Your tutoriel and teaching is very fine. Stay bless .Regards.

@naeemulhassan1426 3 года назад

@@Innozant thanks for prompt repond. Teaching style is very fine. Stay bless & take care. Regards.

@Innozant 3 года назад

@@naeemulhassan1426 Thanks Naeemul Sahab..

@KiyaniPlateOfFlavour 11 месяцев назад

I didn't get the whole procedure

@Innozant 11 месяцев назад

Query ?

@yogeshrao5924 5 месяцев назад

लगता है आपकी मुझसे कोई दुश्मनी है आप मुझे अपना दुश्मन समझते है गुरु जी बाकी हम तो आपसे प्यार करते है 🌹🌹🌹🌹🌹❤

@Innozant 5 месяцев назад

Oho..aisi kya galti humse,

@bhagwatitak7784 Год назад

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)

@amritathakur2036 Год назад

Who is Deeksha Agarwal because mostly example this name show in first

@Innozant Год назад

She is one of the student like You Amrita❤️.Keep Learning.Keep Exploring

@sujathan3783 3 года назад

What about the third match sir?

@Innozant 3 года назад

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 🙏♥️

@sujathan3783 3 года назад

@@Innozant I think in place of +2, something has to be done. I will try sir.

@Innozant 3 года назад

Very Good Sujatha.Try it and let me know 👍