ReePrime
MIS Tricks Q29 Lookup on Each Duplicate Value in Excel

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

R
RAKESH KUMAR

3 Views • Apr 14, 2023

Description

Lookup on Each Duplicate Value in Excel

=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