Friday, February 20, 2009

Return empty string when lookup fails

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

while 'memberno' is subset of 'memberdata' (its first column)
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)