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
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
