IFERROR(Vlookup) question

  • Thread starter Thread starter nologo
  • Start date Start date
N

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
 
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))
 
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
 
And =iferror() was added in xl2007.

It's not available in earlier versions.

nologo wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top