Ask Your Question
0

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
2

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.
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))

edit flag offensive delete link more

Comments

@mariosv - Thank you soo much

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

Question Tools

Stats

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

Seen: 6,054 times

Last updated: Mar 19 '13