JOE Conner wrote:
Wade Smart wrote:
I just received help in the OOForums.
This works:
=CONCATENATE("HOME: ", VLOOKUP(G10,$Sheet2.A2:$Sheet2.B8,2,0))
You have to use a comma everywhere.
:D
Wade
I think that some of the problem may be what OpenOffice you are using.
Some OpenOffice distributions are based on go-oo, and this does use
commas instead of semicolons (but perhaps not everywhere). The help
files have not been updated to account for the comma equation forms. I
presume that the goal was to make it behave more like Excel.
Joe Conner, Poulsbo, WA USA
Interesting - and good to know.
Im on Ubuntu so - maybe thats why.
As long as I know that - I can get things working :D
wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]