On Aug 22, 9:56*am, Claus Busch wrote:
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- Hide quoted text -

- Show quoted text -

Thank you! That worked perfect. Not sure how it works but it does.
What is the reason one must enter CNTL+Shift+Enter? What does that do?