Lookup table/Index

brin · Mar 26, 2018

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:

[TABLE="width: 554"]
<tbody>[TR]
[TD]Double brick[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
</tbody>[/TABLE]
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


Double Brick	2000-current	>300m2	Poor
Brick Veneer	1960-1999	200-300m2	Fair
Weatherboard	1945-1960	120-200m2	Good
Fibrous Cement	1930-1945	<120m2	As New
	Pre 1930

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]Construction:[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Age:[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]Size:[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]Condition:[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffffcc]#ffffcc[/URL] , align: center"]Range:[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: #ccffcc"]Double Brick[/TD]
[TD="bgcolor: #ccffcc"]1960-1999[/TD]
[TD="bgcolor: #ccffcc"]120-200m2[/TD]
[TD="bgcolor: #ccffcc"]Good[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]$1000-$1299[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Lookup

Lookup

	G	H	I	J	K	L	M	N







2000-current	200-300m2	$350-$649	$650-$949	$950-$1299	$1300-$1750
1960-1999	$300-$599	$600-$899	$900-$1249	$1250-$1700
1945-1960	$250-$549	$550-$849	$850-$1199	$1200-$1650
1930-1945	$200-$499	$500-$799	$800-$1149	$1150-$1600
Pre 1930	$150-$449	$450-$749	$750-$1099	$1100-$1550





2000-current	<120m2	$550-$849	$850-$1149	$1150-$1449	$1500-$1950
1960-1999	$500-$799	$800-$1099	$1100-$1399	$1400-$1900
1945-1960	$450-$749	$750-$1049	$1050-$1349	$1350-$1850
1930-1945	$400-$699	$700-$999	$1000-$1299	$1300-$1800
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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Construction[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Age[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] , align: center"]Condition[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "] [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Size[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Poor[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Fair[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]Good[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=003366]#003366[/URL] "]As new[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: #ccccff"]Double Brick[/TD]
[TD="bgcolor: #ccccff"]2000-current[/TD]
[TD="bgcolor: #ccccff"]>300m2 [/TD]
[TD="bgcolor: #ccccff"]$300-$599[/TD]
[TD="bgcolor: #ccccff"]$600-$899[/TD]
[TD="bgcolor: #ccccff"]$900-$1249[/TD]
[TD="bgcolor: #ccccff"]$1250-$1700[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="bgcolor: #ccccff"]1960-1999[/TD]
[TD="bgcolor: #ccccff"]$250-$549[/TD]
[TD="bgcolor: #ccccff"]$550-$849[/TD]
[TD="bgcolor: #ccccff"]$850-$1149[/TD]
[TD="bgcolor: #ccccff"]$1150-$1650[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: #ccccff"]1945-1960[/TD]
[TD="bgcolor: #ccccff"]$200-$499[/TD]
[TD="bgcolor: #ccccff"]$500-$799[/TD]
[TD="bgcolor: #ccccff"]$800-$1100[/TD]
[TD="bgcolor: #ccccff"]$1100-$1600[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: #ccccff"]1930-1945[/TD]
[TD="bgcolor: #ccccff"]$150-$449[/TD]
[TD="bgcolor: #ccccff"]$450-$749[/TD]
[TD="bgcolor: #ccccff"]$750-$1049[/TD]
[TD="bgcolor: #ccccff"]$1050-$1550[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: #ccccff"]Pre 1930[/TD]
[TD="bgcolor: #ccccff"]$100-$399[/TD]
[TD="bgcolor: #ccccff"]$449-$699[/TD]
[TD="bgcolor: #ccccff"]$700-$999[/TD]
[TD="bgcolor: #ccccff"]$1000-$1500[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="bgcolor: #ccccff"]2000-current[/TD]
[TD="bgcolor: #ccccff"]120-200m2 [/TD]
[TD="bgcolor: #ccccff"]$450-$749[/TD]
[TD="bgcolor: #ccccff"]$750-$1049[/TD]
[TD="bgcolor: #ccccff"]$1050-$1349[/TD]
[TD="bgcolor: #ccccff"]$1350-$1850[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]
[TD="bgcolor: #ccccff"]1960-1999[/TD]
[TD="bgcolor: #ccccff"]$400-$699[/TD]
[TD="bgcolor: #ccccff"]$700-$999[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]$1000-$1299[/TD]
[TD="bgcolor: #ccccff"]$1300-$1800[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="bgcolor: #ccccff"]1945-1960[/TD]
[TD="bgcolor: #ccccff"]$350-$649[/TD]
[TD="bgcolor: #ccccff"]$650-$949[/TD]
[TD="bgcolor: #ccccff"]$950-$1249[/TD]
[TD="bgcolor: #ccccff"]$1250-$1750[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]
[TD="bgcolor: #ccccff"]1930-1945[/TD]
[TD="bgcolor: #ccccff"]$300-$599[/TD]
[TD="bgcolor: #ccccff"]$600-$899[/TD]
[TD="bgcolor: #ccccff"]$900-$1199[/TD]
[TD="bgcolor: #ccccff"]$1200-$1700[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="bgcolor: #ccccff"]Pre 1930[/TD]
[TD="bgcolor: #ccccff"]$250-$549[/TD]
[TD="bgcolor: #ccccff"]$550-$849[/TD]
[TD="bgcolor: #ccccff"]$850-$1149[/TD]
[TD="bgcolor: #ccccff"]$1150-$1650[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]22[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]23[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]24[/TD]

</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

Legacy 143009 · Mar 27, 2018

If I were you I would start to make a table in the sense of more like a SQL support table since your date is four-ish dimensional.
I prepared a ready table for you. Just fill the prices then use it

[TABLE="class: grid, width: 332"]
<tbody>[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Double Brick[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Brick Veneer[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Weatherboard[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]Pre 1930[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1930-1945[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1945-1960[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]1960-1999[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]<120m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]120-200m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]200-300m2[/TD]
[TD]Poor[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]As New[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Fair[/TD]
[/TR]
[TR]
[TD]Fibrous Cement[/TD]
[TD]2000-current[/TD]
[TD]>300m2[/TD]
[TD]Poor[/TD]
[/TR]
</tbody>[/TABLE]

brin · Mar 27, 2018

Hi
Thanks for the table.
I just realized that the table I posted didn't show the type of construction as a separate column.

Not sure what to do with the table, SQL etc?

Legacy 143009 · Mar 27, 2018

Nothing to do with SQL. It was just an example. Now, write down the prices one by one to the fifth column. This will be your support Sheet2. Then, on your main Sheet1 assume A1 = Weatherboard, B1 = 1945 - 1960, C1 = <120m2 and D1 = Poor. All you have to do is write a lookup formula in E1. Something like E1 = VLOOKUP(A1&B1&C1&D1, Sheet2!$A$1:$E$320, 5, 0)

I am not in front of the computer. You may have to mess around with lookup formula a bit

brin · Mar 27, 2018

Hi
I tried the formula but couldn't get it to work and don't know what to change to fix it.

Sheet1

	A	B	C	D	E
Weatherboard	1945-1960	<120m2	Fair	#NAME?

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:104px;"><col style="width:76px;"><col style="width:64px;"><col style="width:64px;"><col style="width:84px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

</tbody>

Spreadsheet Formulas

Cell	Formula
E1	=VLOOKUP(AI&B1&C1&D1,Sheet2!$A$1:$E$320,5,0)

Excel tables to the web >> Excel Jeanie HTML 4

Sheet2

	A	B	C	D	E
Double Brick	Pre 1930	<120m2	As New
Double Brick	Pre 1930	<120m2	Good
Double Brick	Pre 1930	<120m2	Fair
Double Brick	Pre 1930	<120m2	Poor
Double Brick	Pre 1930	120-200m2	As New
Double Brick	Pre 1930	120-200m2	Good
Double Brick	Pre 1930	120-200m2	Fair

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="align: right"]900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="align: right"]889[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="align: right"]888[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="align: right"]880[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="align: right"]874[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="align: right"]868[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

[TD="align: right"]862[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Legacy 143009 · Mar 28, 2018

brin said:
Hi
I tried the formula but couldn't get it to work and don't know what to change to fix it.

Sheet1

A B C D E
Weatherboard 1945-1960 <120m2 Fair #NAME?

<tbody>
[TD="align: center"]1[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula
E1 =VLOOKUP(AI&B1&C1&D1,Sheet2!$A$1:$E$320,5,0)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Sheet2

A B C D E
Double Brick Pre 1930 <120m2 As New
Double Brick Pre 1930 <120m2 Good
Double Brick Pre 1930 <120m2 Fair
Double Brick Pre 1930 <120m2 Poor
Double Brick Pre 1930 120-200m2 As New
Double Brick Pre 1930 120-200m2 Good
Double Brick Pre 1930 120-200m2 Fair

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]900[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]889[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]888[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]880[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]874[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]868[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]862[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Ok then try this one. It will work:

{=INDEX(Sheet2!$E$1:$E$320,MATCH($A1&$B1&$C1&$D1,Sheet2!$A$1:$A$320&Sheet2!$B$1:$B$320&Sheet2!$C$1:$C$320&Sheet2!$D$1:$D$320,0))}

This is an array formula so you have to Ctrl+Shift+Enter after paste

brin · Mar 28, 2018

Flashbond said:
Ok then try this one. It will work:

{=INDEX(Sheet2!$E$1:$E$320,MATCH($A1&$B1&$C1&$D1,Sheet2!$A$1:$A$320&Sheet2!$B$1:$B$320&Sheet2!$C$1:$C$320&Sheet2!$D$1:$D$320,0))}

This is an array formula so you have to Ctrl+Shift+Enter after paste

I have copied the formula and clicked Ctrl+Shift+Enter and it show the curvy array quotes but only the formula shows and not the result:

Sheet1

A

B

C

D

E

F

G

H

I

J

K

L

Weatherboard

1945-1960

<120m2

Fair

{=INDEX(Sheet2!$E$1:$E$320,MATCH($A1&$B1&$C1&$D1,Sheet2!$A$1:$A$320&Sheet2!$B$1:$B$320&Sheet2!$C$1:$C$320&Sheet2!$D$1:$D$320,0))}

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

</tbody>

Maybe I am doing something wrong.
I also retyped the formula and it said;too many arguments for this funtion.
I think I copied it exactly.

Excel tables to the web >> Excel Jeanie HTML 4

Legacy 143009 · Mar 29, 2018

It is working for me:

Sample.xlsx

brin · Mar 29, 2018

Many thanks.
I copied the sample file and it works.
Brilliant !
Thanks for all your good work and persistence.

Legacy 143009 · Mar 29, 2018

Your welcome

Lookup table/Index

brin

Board Regular

Excel Facts

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

Similar threads

Forum statistics

Share this page

Lookup table/Index

brin

Board Regular

Excel Facts

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

brin

Board Regular

Legacy 143009

Guest

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock