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,Asbestos Cement.
The selection that I have made from all of the lists is shown in Green:
[TABLE="width: 369"]
<tbody>[TR]
[TD]Brick Veneer
[/TD]
[TD]1945-1960
[/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 $900-$1199
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
I am trying some links-hope they work
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,Asbestos Cement.
The selection that I have made from all of the lists is shown in Green:
[TABLE="width: 369"]
<tbody>[TR]
[TD]Brick Veneer
[/TD]
[TD]1945-1960
[/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 $900-$1199
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
I am trying some links-hope they work

