Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-10-02 Thread Chuck Evans
Delete [EMAIL PROTECTED] from your list. - Original Message From: Brian Barker <[EMAIL PROTECTED]> To: users@openoffice.org Sent: Sunday, September 28, 2008 6:29:29 PM Subject: Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria

Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-10-02 Thread Chuck Evans
Delete [EMAIL PROTECTED] from your list. - Original Message From: Andis <[EMAIL PROTECTED]> To: users@openoffice.org Sent: Sunday, September 28, 2008 4:04:00 PM Subject: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the fir

Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-09-28 Thread Andis
Thank you a lot! This really helped. I got error result at the beginning using this advice because I have different locale settings and instead of 'FALSE' I have to write 'APLAMS'. Is there also solution for random values in table to chose variable directly on the base of values in the table

Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-09-28 Thread Brian Barker
At 23:04 28/09/2008 +0300, Andis Noname wrote: I'm looking if there is easy possibility to chose variable from the table, like in example below, to use in calculations is another table. I have table like this, but much longer, to chose variables from: *Average height (m)* *Aspen* *Grey alder*

[users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-09-28 Thread Andis
Hello! I'm looking if there is easy possibility to chose variable from the table, like in example below, to use in calculations is another table. I have table like this, but much longer, to chose variables from: *Average height (m)**Aspen* *Grey alder * *Birch* 1 2000