Lookup on Each Duplicate Value in Excel <br /><br />=IFERROR(INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8=H2,ROW($A$1:$A$8)),ROW()-1)),"") <br /><br />Supporting File Link <br /><br />https://docs.google.com/spreadsheets/d/1ZQRkxkzS9NkBBZ6qVlu9uuUXZWMMYQBJ/edit?usp=share_link&ouid=108365514073073043927&rtpof=true&sd=true <br /><br />Microsoft Excel Course: Advanced Excel Training <br /><br />https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59
