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 2000 2000
2 1800 1800 1800
3 1600 1600 1600
4 1600 1600 1600
5 1600 1600 1600
6 1600 1600 1600
7 1500 1600 1500
8 1400 1500 1400
9 1300 1500 1300
10 1200 1500 1200
11 1100 1300 1100
And I have another table with the results of forest inventory, which
contains columns specie and average height, besides other 245 variables.
I need additional column with some kind of lookup field, where according
to a specie and average tree height I can see regulatory numbers of
trees (values in the first table). For instance if the main specie is
Aspen and average height of trees is 10 m, regulatory number of trees
should be 1200.
What are the options to do it, preferably using array functions?
Sincerely,
Andis
