Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
MIS Tricks Q29 Lookup on Each Duplicate Value in Excel
3 Views • Apr 14, 2023
Description
=IFERROR(INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8=H2,ROW($A$1:$A$8)),ROW()-1)),"")
Supporting File Link
https://docs.google.com/spreadsheets/d/1ZQRkxkzS9NkBBZ6qVlu9uuUXZWMMYQBJ/edit?usp=share_link&ouid=108365514073073043927&rtpof=true&sd=true
Microsoft Excel Course: Advanced Excel Training
https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59
Keywords & Tags
More from User
39 Live SQL Practice Session 22 Feb 2026
RAKESH KUMAR
37 Live SQL Practice Session 1 Feb 2026
RAKESH KUMAR
36 Live SQL Practice Session 25 Jan 2026
RAKESH KUMAR
38 Live SQL Practice Session 15 Feb 20263
RAKESH KUMAR
35 Live SQL Practice Session 18 Jan 2026
RAKESH KUMAR
34 Live SQL Practice Session 11 Jan 2026
RAKESH KUMAR
Related Videos
LOOKUP FORMULA | How To Use Lookup In Excel Step by Step | Learn Lookup Function In Excel
OUR GREAT COUNTRY INDIA
Excel (Macro) VBA Part-2 | VBA - Cell Referencing | Debug Function - Step into | VBA Coding in Hindi
Tech Guru Plus(Nazim Khan)
MIS Excel VBA Macro Tips-2
RAKESH KUMAR
Excel (Macro) VBA Part-3 | Copy Data to another Sheet in Excel by Macro | VBA Coding in Hindi
Tech Guru Plus(Nazim Khan)
Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need | Read Books Online
Patriciabperron
[PDF] Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need | Read Books Online|Ebook Download
Gesta