Page 1 of 1

range of cells as argument

Posted: Fri Jun 03, 2016 9:48 am
by icegood
Hi again. From my previous post i was unable to work with complicated arrays (e.g. those ones that have > 1 values in each array element)
Now i've tried to workaround it via cell ranges but while parsing
VLOOKUP(V9, A1:C3, 3, 1)
i've obtained error
E4003: Invalid fractional number
I wonder is there at least something REALLY works in this library?

Re: range of cells as argument

Posted: Fri Jun 03, 2016 11:18 am
by icegood
Sorry, my fault. I hasn't used ';' as delimiter between arguments. Everything works!