Change the match part

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




MATCH(1,(H1:H30=A1)*(I1:I30=B1),0)

and you need to enter the formula with ctrl + shift & enter


--

Regards,

Peo Sjoblom






"Nikki" wrote in message
...
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),"")