Mark,

This array formula worked for me.

=INDEX(B1:B4,MATCH(H1,LEFT(B1:B4,FIND(",",B1:B4,1)-1),0))

Commit with Ctrl - Shift - Enter simultaneously, not just enter. If
you do it right the formula will have {} around it in the formula bar.
This formula assumes that the LN,FN are separated by a comma. This
matches the entire last name rather than just the first 4 characters.



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544442