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
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:124.67px;"><col style="width:128px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:86px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Excel tables to the web >> Excel Jeanie HTML 4
Excel tables to the web >> Excel Jeanie HTML 4
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 | |||
5 | Double Brick | 2000-current | >300m2 | $300-$599 | $600-$899 | $900-$1249 | $1250-$1700 | |
6 | 1960-1999 | $250-$549 | $550-$849 | $850-$1149 | $1150-$1650 | |||
7 | 1945-1960 | $200-$499 | $500-$799 | $800-$1100 | $1100-$1600 | |||
8 | 1930-1945 | $150-$449 | $450-$749 | $750-$1049 | $1050-$1550 | |||
9 | Pre 1930 | $100-$399 | $449-$699 | $700-$999 | $1000-$1500 | |||
10 | 2000-current | 200-300m2 | $350-$649 | $650-$949 | $950-$1299 | $1300-$1750 | ||
11 | 1960-1999 | $300-$599 | $600-$899 | $900-$1249 | $1250-$1700 | |||
12 | 1945-1960 | $250-$549 | $550-$849 | $850-$1199 | $1200-$1650 | |||
13 | 1930-1945 | $200-$499 | $500-$799 | $800-$1149 | $1150-$1600 | |||
14 | Pre 1930 | $150-$449 | $450-$749 | $750-$1099 | $1100-$1550 | |||
15 | 2000-current | 120-200m2 | $450-$749 | $750-$1049 | $1050-$1349 | $1350-$1850 | ||
16 | 1960-1999 | $400-$699 | $700-$999 | $1000-$1299 | $1300-$1800 | |||
17 | 1945-1960 | $350-$649 | $650-$949 | $950-$1249 | $1250-$1750 | |||
18 | 1930-1945 | $300-$599 | $600-$899 | $900-$1199 | $1200-$1700 | |||
19 | Pre 1930 | $250-$549 | $550-$849 | $850-$1149 | $1150-$1650 | |||
20 | 2000-current | <120m2 | $550-$849 | $850-$1149 | $1150-$1449 | $1500-$1950 | ||
21 | 1960-1999 | $500-$799 | $800-$1099 | $1100-$1399 | $1400-$1900 | |||
22 | 1945-1960 | $450-$749 | $750-$1049 | $1050-$1349 | $1350-$1850 | |||
23 | 1930-1945 | $400-$699 | $700-$999 | $1000-$1299 | $1300-$1800 | |||
24 | Pre 1930 | $350-$649 | $650-$949 | $950-$1249 | $1250-$1750 |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:124.67px;"><col style="width:128px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:86px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Excel tables to the web >> Excel Jeanie HTML 4
Excel tables to the web >> Excel Jeanie HTML 4