Hi,

Thanks they all work.

Now I have come across the problem that some people have the same last name
so I need to change the formula so that it checks First and Last names
(Columns A, B with Columns H, I)

Any ideas?

Regards

Nikki

"Harlan Grove" wrote:

"OssieMac" wrote...
....
=IF(ISNA(INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0) ,10)),"",
INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0),10))
....

You could shorten the existence check considerably.

=IF(COUNTIF($H$1:$H$30,$A1),
INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0),10),"")

or, possibly faster recalculating,

=IF(COUNT(MATCH($A1,$H$1:$H$30,0)),
INDEX($A$1:$J$30,MATCH($A1,$H$1:$H$30,0),10),"")