Find and Lookup the 2nd, 3rd and Nth Matching Values Using VLOOKUP in Excel Bangla
Find and Lookup the 2nd, 3rd and Nth Matching Values Using VLOOKUP in Excel Bangla
We know that VLOOKUP formula is useful to fetch the first matching item from a list. So what would you do if you need 2nd (or 3rd etc.) matching item from a list?
To get the nth MATCH with VLOOKUP, you'll need to add a helper column to your table that constructs a unique id that includes the count.
This formula depends on a helper column, which is added as the first column to the source data table. The helper column contains a formula which builds a unique lookup value from an existing id and a counter. The counter counts the number of times the unique id has appeared in the data table.
In this tutorial, I will cover one way to look-up the second or the Nth value in Excel:
Using a helper column.
in my next tutorial i will cover it by
Using index and match array formulas.
I think you have enjoyed this video.
If this tutorial really helps you, please like, comment, subscribe and share with your close friends. This is #msexcel #bangla #tutorial.
............................................................................
..............Subscribe to Get More Videos...........
https://www.youtube.com/c/MaMuNAcadem...
............................................................................
..................................................................................................
Most Favorite Videos
আমার ভিডিও /টিউটোরিয়াল কোথা থেকে শুরু করবেন ?
• How My Tutorial Arranged_About MamuN Acad...
MS Excel Bangla Tutorial Playlist :
Excel Super Secret Tips & Tricks: https://goo.gl/5qSphJ
Mastery of If Function Bangla: https://goo.gl/jY76m4
MS Excel Essential Course : https://goo.gl/7EX1hk
MS Excel Intermediate Course: https://goo.gl/iatnNz
MS Excel Advanced Course: https://goo.gl/WFrvzU
MS Excel Formulas & Functions: https://goo.gl/7Da7oZ
MS Excel Pivot Table Magic: https://goo.gl/NGp13W
MS Word Essential Course: https://goo.gl/SVXefG
Magic of Conditional Formatting Bangla : https://goo.gl/j4N3sH
Mastery of VLOOKUP Function : https://goo.gl/1YAZ5y
Result Sheet Making Bangla : https://goo.gl/VnuZk6
Salary Sheet Making Hidden Tricks : https://goo.gl/KXsfyh
Master of Pivot Table : https://goo.gl/PaGUzj
MS Word Magic and Tips and Tricks : https://goo.gl/6b25kB
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : https://plus.google.com/mamunacademy
LinkenIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................
.................Social Media.................
Facebook Page : / mamunacademy4u
Facebook Group : / mamunacademy
Google+ : https://plus.google.com/mamunacademy
LinkedIn : / abdulla-al-mamun-172629b4
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & http://www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► http://bit.ly/OffTMDesigns
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.