Excel Vlookup in an if statement

[mgbeye]

We have checked this formula several times, but it still will not work. If the statement is true it returns the 0 which is correct. If it is false it returns #N/A. Does anyone know why. (All cell references are correct)

=IF(ERROR.TYPE(VLOOKUP(CONCATENATE(A28," Total"),'[7.16-7.22.xls]Sheet1'!$G$2:$I$482,3,FALSE))=7, 0, (VLOOKUP(CONCATENATE(A28," Total"),'[7.16-7.22.xls]Sheet1'!$G$2:$I$482,3,FALSE)))

 

[ilses]

Guess as to the cause: the ERROR.TYPE function returns #N/B if there is no error.

Solution: use ISNA.

With simpeler references to make it easier to read:

=IF(ISNA(VLOOKUP(CONCATENATE(A28,"Total&quot,G2:I5,3,FALSE)),0, VLOOKUP(CONCATENATE(A28, "Total&quot,G2:I5,3,FALSE))

IS