I have a cell as follows: =if(a5="";"";vlookup(a5;'file:///media/myoffice/accounting/chart_of_accounts.ods'#$chart. $a9:b96;2))
a5 is a GL account number. The chart of accounts has 2 collumns: A=gl acct #s, B=Acct Names I am getting an error 508 which I check to find that the number of brackets (or paren) are not equal. Does someone see what I am doing wrong, or is this an insect? tia, John Suse 11.1, OOo 3.0 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
