IF statement help

Confusicous · Oct 2, 2009

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!

Sean Timmons · Oct 2, 2009

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

Bob Phillips · Oct 2, 2009

If you have Excel 2007

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

Confusicous · Oct 2, 2009

Thanks for the help. I appreciate it.

Bob Phillips said:
If you have Excel 2007

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

--
__________________________________
HTH

Bob