Thursday, May 23, 2013

MS. Excel: ISNA function

To handle error #N/A In Microsoft Excel, when use VLOOKUP function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number.
One problem that can occur is when there is not a match so it returns N/A. Here is an example:


=IF(IF(ISNA(VLOOKUP($E3,Sheet2!$A$2:$S$889,7,FALSE)),0,VLOOKUP($E3,Sheet2!$A$2:$S$889,7,FALSE))>0,"JAMSOSTEK","")

No comments: