IFERROR(Vlookup) question

[nologo]

Hello,
I have a excel spread sheet in 2007 with the following code:

=IFERROR(VLOOKUP(F6,$K$3:$L$23,2), 0)

However, this doesnt work on earlier versions of excel, any idea?
Basically it returns a value of 0 if it doesnt fit the requirements.
such as col is empty etc

Thanks

 

[Joel]

Tis line of code is wrong. The zero is in the wrong place

from
=IFERROR(VLOOKUP(F6,$K$3:$L$23,2), 0)

to
=IFERROR(VLOOKUP(F6,$K$3:$L$23,2, 0))

 

[Michael]

=IF(ISERROR(VLOOKUP(F6,$K$3:$L$23,2), 0,VLOOKUP(F6,$K$3:$L$23,2))

 

[nologo]

Tis line of code is wrong.  The zero is in the wrong place

from
=IFERROR(VLOOKUP(F6,$K$3:$L$23,2), 0)

to
=IFERROR(VLOOKUP(F6,$K$3:$L$23,2, 0))








- Show quoted text -

=IFERROR(ROUND(((E3/D3)*100),0),0)
how about this?this doesnt work either..but does in 2007

 

[Joel]

Iferror has only one parameter. both cases you had two parameters.

 

[Dave Peterson]

And =iferror() was added in xl2007.

It's not available in earlier versions.

nologo wrote:

 

[nologo]

And =iferror() was added in xl2007.

It's not available in earlier versions.

nologowrote:

<<snipped>>

Thankyou dave, is there a conversion?

 

[Dave Peterson]

You can rewrite the formula:

=if(iserror(yourformula),0,yourformula)