Hi,
I use the following formula on one of my spreadsheets
=VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE) but it returns a #N/A error
message. I want to change the formula that it displays a 0 (zero) instead of
#N/A. I thought of including an ISERROR statement but the formula keeps
returning the error message.

Can somebody please help?

Thanks

Minos

Minos wrote:
Hi,
I use the following formula on one of my spreadsheets
=VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE) but it returns a #N/A error
message. I want to change the formula that it displays a 0 (zero)
instead of #N/A. I thought of including an ISERROR statement but the
formula keeps returning the error message.

Can somebody please help?

Thanks

Minos

Hi Minos,

this will show you 0 instead of #N/A:

=IF(ISNA(VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE)) ,0,VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE))

this will show you a blank instead of #N/A:

=IF(ISNA(VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE)) ,"",VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE))

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

try following function.

=IF(ISNA(VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE)) ,0,VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE))


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=558166

My problem is solved. Thanks you guys for being helpfull.

Minos

"Minos" wrote:

Hi,
I use the following formula on one of my spreadsheets
=VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE) but it returns a #N/A error
message. I want to change the formula that it displays a 0 (zero) instead of
#N/A. I thought of including an ISERROR statement but the formula keeps
returning the error message.

Can somebody please help?

Thanks

Minos

Minos Wrote:
My problem is solved. Thanks you guys for being helpfull.

Minos



you are welcome.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=558166