I have the formula you gave me. However, the result is giving me #N/A.

=IF(COUNTIF(children!$A$2:$E$1545,'member
list'!B180)1,OFFSET(children!A179,MATCH('member
list'!B180,children!$A$2:$E$1545,0)+1,0),"")

"Cutter" wrote:


That refers to the first cell above the first name in Col B.

I assumed you have a header row in row 1 and your names start in Row
2.

If your names start in Row 3 then change that reference to B2


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=521875