Formula Error

[roxiemayfield]

I have the following formula with an error. I am trying to get an na to be a
-0- if the lookup is 0.

=IF(ISNA((VLOOKUP($B13,pmp3w1,3,0)),0,VLOOKUP($B13,pmp3w1,3,FALSE)

 

[Mike H]

Try

=IF(ISNA(VLOOKUP(B13,pmp3w1,3,0)),0,VLOOKUP(B13,pmp3w1,3,0))

Mike

 

[roxiemayfield]

Thank you so much! That works.

Try

=IF(ISNA(VLOOKUP(B13,pmp3w1,3,0)),0,VLOOKUP(B13,pmp3w1,3,0))

Mike

 

[Mike H]

Glad I could help, it was only a parenthesis problem