Hi,
I have so tried to answer this, 5hours now and 5 forums and my brain still can't get my head around it.
I would like to return a number based on two conditions, i.e:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Assuming above is two tables the first would have the area and soil type in, I want to put a formula in the class cell next to this that would look up the other table find Moray, check to see if the soil is sandy or mineral in the first table and return the site class number associated to it. In this example returning 1, but if I changed area to Perth it would return 4.
Anybody able to help, please.
Thanks
I have so tried to answer this, 5hours now and 5 forums and my brain still can't get my head around it.
I would like to return a number based on two conditions, i.e:
Area | Soil | Class | Area | Soil | ||
Moray | Sandy | Sandy | Mineral | |||
Moray | 1 | 2 | ||||
Perth | 4 | 2 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Assuming above is two tables the first would have the area and soil type in, I want to put a formula in the class cell next to this that would look up the other table find Moray, check to see if the soil is sandy or mineral in the first table and return the site class number associated to it. In this example returning 1, but if I changed area to Perth it would return 4.
Anybody able to help, please.
Thanks