IF ISNA Workings

[Ferengi]

Hi

I want that frustrating #N/A message not to show when I do a vlookup.

I've attched my formula, what am I doing wrong?

IF(ISNA(VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE);0;VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE)

Keep's telling me I have to many arguments in formula.

<strike></strike>

 

[FormR]

Hi, you had some misplaced parenthesis:

=IF(ISNA(VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE));0;VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE))

But, depending on your Excel version you could also try these shorter alternatives.

=IFNA(VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE);0)

=IFERROR(VLOOKUP(A5;'Naasif List'!$A$3:$T$237;4;FALSE);0)

 

[Ferengi]

Thanks man.

Now I look like a genius too.

 

[Aladin Akyurek]

What is the version of Excel you areworking with?