ExcelBanter - Formula Error

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula Error (https://www.excelbanter.com/excel-worksheet-functions/197848-formula-error.html)

roxiemayfield

Formula Error

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

Formula Error

Try

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

Mike

"roxiemayfield" wrote:

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)

roxiemayfield

Formula Error

Thank you so much! That works.

"Mike H" wrote:

Try

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

Mike

"roxiemayfield" wrote:

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

Formula Error

Glad I could help, it was only a parenthesis problem

"roxiemayfield" wrote:

Thank you so much! That works.

"Mike H" wrote:

Try

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

Mike

"roxiemayfield" wrote:

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)

All times are GMT +1. The time now is 12:42 PM.