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 />