"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),"")