Read HELP. If you need more, post your formula and the data involved.
S Simon Lloyd Apr 29, 2009 #2 it's because the lookup value cannot be found, If you are only worried about N/A then use this ISNA function like this: =IF(ISNA(VLOOKUP(A1,A2:C10,2,FALSE)),"None",VLOOKUP(A1,A2:C10,2,FALSE)) You can change ISNA for ISERROR to handle all errors. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)
it's because the lookup value cannot be found, If you are only worried about N/A then use this ISNA function like this: =IF(ISNA(VLOOKUP(A1,A2:C10,2,FALSE)),"None",VLOOKUP(A1,A2:C10,2,FALSE)) You can change ISNA for ISERROR to handle all errors. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)
