I'm using this VLookup formula, =VLOOKUP(B19,$B$698:$D$1318,3,FALSE),
to match birth dates with names. The problem I'm running into is when
I have 2 of the same LAST names. This formula tends to populate the
associated cells with only the first date. Cell D6 should read
8/15/1986 as reference in D801 below.

I've tried nesting but it didn't work. Any ideas on how to fix this
problem?

B C D E
5 Smith Joe 2/25/1984 28
6 Smith Mary 2/25/1984 28
---------------------------------------------------------------------

800 Smith Joe 2/25/1984
801 Smith Mary 8/15/1986