Hi Guys
I have set up a dropdown box that allows me to select for 4 criteria-Construction, age, size,condition ( see Yellow coloured headings).
Under the heading-Construction there are four selections- Double Brick, Brick Veneer,Weatherboard,Fibrous Cement.
The selection that I have made from all of the lists is shown in Green:
<tbody>
</tbody>I want to lookup the added value from the schedule. The correct answer is $1000-$1299.
I assume that I need a Lookup Table/Index or something, but I have no real idea and will rely on you experts to help me out.
Please assume that I know nothing (which is probably the case) and explain it clearly or better still give me the formula that I can use.
Thankyou in anticipation
Lookup
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Lookup
Lookup
I have set up a dropdown box that allows me to select for 4 criteria-Construction, age, size,condition ( see Yellow coloured headings).
Under the heading-Construction there are four selections- Double Brick, Brick Veneer,Weatherboard,Fibrous Cement.
The selection that I have made from all of the lists is shown in Green:
Double brick | 1960-1999 | 120-200m2 | Good |
<tbody>
</tbody>
I assume that I need a Lookup Table/Index or something, but I have no real idea and will rely on you experts to help me out.
Please assume that I know nothing (which is probably the case) and explain it clearly or better still give me the formula that I can use.
Thankyou in anticipation
Lookup
A | B | C | D | E | |
1 | Construction: | Age: | Size: | Condition: | Range: |
2 | Double Brick | 1960-1999 | 120-200m2 | Good | $1000-$1299 |
3 | Double Brick | 2000-current | >300m2 | Poor | |
4 | Brick Veneer | 1960-1999 | 200-300m2 | Fair | |
5 | Weatherboard | 1945-1960 | 120-200m2 | Good | |
6 | Fibrous Cement | 1930-1945 | <120m2 | As New | |
7 | Pre 1930 |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Lookup
Lookup
G | H | I | J | K | L | M | N | |
3 | Construction | Age | Condition | |||||
4 | Size | Poor | Fair | Good | As new |