MIS Tricks Q29 Lookup on Each Duplicate Value in Excel
- last year
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
=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