Hi Steve,

Am Wed, 22 Aug 2012 09:40:39 -0700 (PDT) schrieb Steve Ross:

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

try:
=INDEX($D$698:$D$1318,MATCH(B19&C19,$B$698:$B$1318 &$C$698:$C$1318,0))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2