Iferror with vlookup

[Fayaz]

Hi all,

I’m trying to get users in my company to use Libre Office instead of MS Office. One specific user is using in Excel a function that contains both ‘iferror and vlookup’.

Following is an example, I’m not sure if it makes any sense

=IFERROR(VLOOKUP(B20,‘Price List’!$A$1:$D$222,2,FALSE),0)

Can anyone please give me a solution so that I can do the same function in Libre Office?

Thank you in advance
Fayaz

[mariosv]

What is you LibreOffice version?, the IFERROR() function was implemented in 4.0 version.
http://www.libreoffice.org/download

or
IF(ISERROR(VLOOKUP(B20,‘Price List’!$A$1:$D$222,2,FALSE)),0,VLOOKUP(B20,‘Price List’!$A$1:$D$222,2,FALSE))

[Fayaz]

@mariosv - Thank you soo much