Lookup on Each Duplicate Value in Excelbr 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 Linkbr br