IF statement help
If you have Excel 2007
=IFERROR(VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE),0)
--
__________________________________
HTH
Bob
"Confusicous" wrote in message
...
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!
|