I have the below formula which is returning a name (Column B) after matching a Date of Birth in Column C. The index-match formula is copied down a large table. It all works perfectly until there are twins with the same DOB. Any idea how to resolve?
=IFERROR(INDEX($B$6:$B$203,MATCH(AT6,$C$6:$C$203,0)),"")
=IFERROR(INDEX($B$6:$B$203,MATCH(AT6,$C$6:$C$203,0)),"")