Ask Your Question

Help with Err 508 in Calc

asked 2018-01-10 10:33:05 +0200

JonNew gravatar image

I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.

edit retag flag offensive close merge delete


Do you write comma as delimiter of parameters? Try semicolon

JohnSUN gravatar imageJohnSUN ( 2018-01-10 11:37:02 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-11 21:15:41 +0200

JonNew gravatar image

Thank you, JohnSun, semicolons work. Also, found the answer thanks to question by and answer by Ratslinger:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-10 10:33:05 +0200

Seen: 197 times

Last updated: Jan 11