and as your friend, AA, would suggest.. it is also better to look for positive results first...

e.g. =IF(ISNUMBER(MATCH(lookup_value,lookup_array,0)),VLOOKUP(criteria,table_array,col_index_num,range_look up),0)