Return empty string when lookup fails

IF(COUNTIF(memberno;A1);VLOOKUP(A1;memberdata;2;0);"")

while 'memberno' is subset of 'memberdata' (its first column)