=IF(ISNA(VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE)),0, VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE))

"Confusicous" wrote:

I need an IF statement that will turn the N/A to 0

Here is my Vlookup formula:

=VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE)

Thanks for the help!