ExcelBanter - IF statement help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF statement help (https://www.excelbanter.com/excel-discussion-misc-queries/244397-if-statement-help.html)

Confusicous

IF statement help

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

IF statement help

=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!

Bob Phillips[_3_]

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!

Confusicous

IF statement help

Thanks for the help. I appreciate it.

"Bob Phillips" wrote:

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!

All times are GMT +1. The time now is 02:24 AM.