I have created a function "vlook up" which worked fine,
T tjtjjtjt Nov 28, 2004 #2 One way: =IF(ISERROR(yourVLOOKUPfunction),"",yourVLOOKUPfunction) This would make the cell look empty instead of showing the error. It would not fix the error, though. tj
One way: =IF(ISERROR(yourVLOOKUPfunction),"",yourVLOOKUPfunction) This would make the cell look empty instead of showing the error. It would not fix the error, though. tj
R Rob Nov 28, 2004 #3 Paula, using if(isna would trap NAs =IF(ISNA((VLOOKUP(A2,A3:B6,2,FALSE))),"",VLOOKUP(A2,A3:B6,2,FALSE)) Regards, Rob
Paula, using if(isna would trap NAs =IF(ISNA((VLOOKUP(A2,A3:B6,2,FALSE))),"",VLOOKUP(A2,A3:B6,2,FALSE)) Regards, Rob
