Lookup table/Index

brin

Board Regular
Joined
Sep 7, 2008
Messages
202
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 brick1960-1999120-200m2Good

<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

ABCDE
1Construction:Age:Size:Condition:Range:
2Double Brick1960-1999120-200m2Good$1000-$1299
3Double Brick2000-current>300m2Poor
4Brick Veneer1960-1999200-300m2Fair
5Weatherboard1945-1960120-200m2Good
6Fibrous Cement1930-1945<120m2As New
7Pre 1930

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4





Lookup

Lookup

GHIJKLMN
3ConstructionAge Condition
4SizePoorFairGoodAs new
5Double Brick2000-current>300m2 $300-$599$600-$899$900-$1249$1250-$1700
61960-1999$250-$549$550-$849$850-$1149$1150-$1650
71945-1960$200-$499$500-$799$800-$1100$1100-$1600
81930-1945$150-$449$450-$749$750-$1049$1050-$1550
9Pre 1930$100-$399$449-$699$700-$999$1000-$1500
102000-current200-300m2 $350-$649$650-$949$950-$1299$1300-$1750
111960-1999$300-$599$600-$899$900-$1249$1250-$1700
121945-1960$250-$549$550-$849$850-$1199$1200-$1650
131930-1945$200-$499$500-$799$800-$1149$1150-$1600
14Pre 1930$150-$449$450-$749$750-$1099$1100-$1550
152000-current120-200m2 $450-$749$750-$1049$1050-$1349$1350-$1850
161960-1999$400-$699$700-$999$1000-$1299$1300-$1800
171945-1960$350-$649$650-$949$950-$1249$1250-$1750
181930-1945$300-$599$600-$899$900-$1199$1200-$1700
19Pre 1930$250-$549$550-$849$850-$1149$1150-$1650
202000-current<120m2 $550-$849$850-$1149$1150-$1449$1500-$1950
211960-1999$500-$799$800-$1099$1100-$1399$1400-$1900
221945-1960$450-$749$750-$1049$1050-$1349$1350-$1850
231930-1945$400-$699$700-$999$1000-$1299$1300-$1800
24Pre 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

Board Regular
Joined
Sep 7, 2008
Messages
202
;)
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Flashbond

Well-known Member
Joined
Mar 13, 2010
Messages
670
In Sample2.xlsx, on the data validation list, "200-300m2 " has a trailing space for example. You must be careful.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,837
Messages
5,638,643
Members
417,040
Latest member
EC1728

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top