Ask Your Question

iferror with vlookup [closed]

asked 2013-03-19 13:52:34 +0200

Fayaz gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 03:27:17.948099

1 Answer

Sort by » oldest newest most voted

answered 2013-03-19 14:10:22 +0200

m.a.riosv gravatar image

What is you LibreOffice version?, the IFERROR() function was implemented in 4.0 version.

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

edit flag offensive delete link more


@mariosv - Thank you soo much

Fayaz gravatar imageFayaz ( 2013-03-20 05:52:10 +0200 )edit

Question Tools


Asked: 2013-03-19 13:52:34 +0200

Seen: 7,588 times

Last updated: Mar 19 '13