Lookup table/Index

[brin]

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:

Double brick

1960-1999

120-200m2

Good

<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

	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

 

[brin]

I have carefully revised the data on the spreadsheet and now it works perfectly.
Don't know what was wrong with the way I copied it before or what has made it work, but it is working properly now, so that is great.
Many thanks for all your help.

 

[Legacy 143009]

In Sample2.xlsx, on the data validation list, "200-300m2 " has a trailing space for example. You must be careful.