Spreadsheet: 807895d1670147977-lookup-value-inside-a-range-of-values-rec-zone-calculations
Sheet: Table 1

Item | Postcode from | Postcode to | Zone | Rating |  |  |  | Rebate ends | 2031 |  |  |  |  |  |  |  |  | [NAME] Deeming Period Years x System Size in kW = Number of STCs created
1 | 0 | 799 | 3 | 1.382 |  |  |  | Year | 2022
2 | 800 | 869 | 2 | 1.536 |  |  |  | Years remaining
3 | 870 | 879 | 1 | 1.622 |  |  |  | Size | 6.64
4 | 880 | 1000 | 2 | 1.536 |  |  |  | Postcode | 2000 | <---------  Enter post code.  It will search the list to find which range it fits, then add the "rating" to cell J6. I've highlighted the cells yellow that 2000 is in postcode range. So, if this field had "910" it would use item 4 and rating would be 1.536.
5 | 1001 | 2356 | 3 | 1.382 |  |  |  | Zone | 3
6 | 2357 | 2357 | 2 | 1.536 |  |  |  | Rating | 1.382
7 | 2358 | 2384 | 3 | 1.382 |  |  |  | ANSWER |  | <--------- answer is rounded down
8 | 2385 | 2393 | 2 | 1.536
9 | 2394 | 2395 | 3 | 1.382
10 | 2396 | 2398 | 2 | 1.536
11 | 2399 | 2399 | 3 | 1.382
12 | 2400 | 2400 | 2 | 1.536
13 | 2401 | 2404 | 3 | 1.382
14 | 2405 | 2407 | 2 | 1.536
15 | 2408 | 2410 | 3 | 1.382
16 | 2411 | 2414 | 2 | 1.536
17 | 2415 | 2536 | 3 | 1.382
18 | 2537 | 2537 | 4 | 1.185
19 | 2538 | 2544 | 3 | 1.382
20 | 2545 | 2557 | 4 | 1.185
21 | 2558 | 2626 | 3 | 1.382
22 | 2627 | 2629 | 4 | 1.185
23 | 2630 | 2630 | 3 | 1.382
24 | 2631 | 2639 | 4 | 1.185
25 | 2640 | 2820 | 3 | 1.382
26 | 2821 | 2842 | 2 | 1.536
27 | 2843 | 2872 | 3 | 1.382
28 | 2873 | 2874 | 2 | 1.536
29 | 2875 | 2876 | 3 | 1.382
30 | 2877 | 2889 | 2 | 1.536
31 | 2890 | 2897 | 3 | 1.382
32 | 2898 | 2899 | 3 | 1.382
33 | 2900 | 2999 | 3 | 1.382
34 | 3000 | 3390 | 4 | 1.185
35 | 3391 | 3398 | 3 | 1.382
36 | 3399 | 3413 | 4 | 1.185
37 | 3414 | 3426 | 3 | 1.382
38 | 3427 | 3474 | 4 | 1.185
39 | 3475 | 3514 | 3 | 1.382
40 | 3515 | 3516 | 4 | 1.185
41 | 3517 | 3520 | 3 | 1.382
42 | 3521 | 3524 | 4 | 1.185
43 | 3525 | 3538 | 3 | 1.382
44 | 3539 | 3539 | 4 | 1.185
45 | 3540 | 3549 | 3 | 1.382
46 | 3550 | 3560 | 4 | 1.185
47 | 3561 | 3569 | 3 | 1.382
48 | 3570 | 3570 | 4 | 1.185
49 | 3571 | 3606 | 3 | 1.382
50 | 3607 | 3617 | 4 | 1.185
51 | 3618 | 3622 | 3 | 1.382
52 | 3623 | 3628 | 4 | 1.185
53 | 3629 | 3657 | 3 | 1.382
54 | 3658 | 3684 | 4 | 1.185
55 | 3685 | 3687 | 3 | 1.382
56 | 3688 | 3724 | 4 | 1.185
57 | 3725 | 3731 | 3 | 1.382
58 | 3732 | 3999 | 4 | 1.185
59 | 4000 | 4416 | 3 | 1.382
60 | 4417 | 4417 | 2 | 1.536
61 | 4418 | 4422 | 3 | 1.382
62 | 4423 | 4423 | 2 | 1.536
63 | 4424 | 4426 | 3 | 1.382
64 | 4427 | 4473 | 2 | 1.536
65 | 4474 | 4476 | 1 | 1.622
66 | 4477 | 4478 | 2 | 1.536
67 | 4479 | 4485 | 1 | 1.622
68 | 4486 | 4490 | 2 | 1.536
69 | 4491 | 4492 | 1 | 1.622
70 | 4493 | 4499 | 2 | 1.536
71 | 4500 | 4721 | 3 | 1.382
72 | 4722 | 4722 | 2 | 1.536
73 | 4723 | 4723 | 3 | 1.382
74 | 4724 | 4735 | 2 | 1.536
75 | 4736 | 4736 | 1 | 1.622
76 | 4737 | 4824 | 3 | 1.382
77 | 4825 | 4827 | 2 | 1.536
78 | 4828 | 4828 | 3 | 1.382
79 | 4829 | 4829 | 2 | 1.536
80 | 4830 | 5261 | 3 | 1.382
81 | 5262 | 5263 | 4 | 1.185
82 | 5264 | 5270 | 3 | 1.382
83 | 5271 | 5300 | 4 | 1.185
84 | 5301 | 5429 | 3 | 1.382
85 | 5430 | 5450 | 2 | 1.536
86 | 5451 | 5653 | 3 | 1.382
87 | 5654 | 5669 | 2 | 1.536
88 | 5670 | 5679 | 3 | 1.382
89 | 5680 | 5699 | 2 | 1.536
90 | 5700 | 5709 | 3 | 1.382
91 | 5710 | 5722 | 2 | 1.536
92 | 5723 | 5724 | 1 | 1.622
93 | 5725 | 5733 | 2 | 1.536
94 | 5734 | 5799 | 1 | 1.622
95 | 5800 | 6243 | 3 | 1.382
96 | 6244 | 6250 | 4 | 1.185
97 | 6251 | 6254 | 3 | 1.382
98 | 6255 | 6270 | 4 | 1.185
99 | 6271 | 6315 | 3 | 1.382
100 | 6316 | 6357 | 4 | 1.185
101 | 6358 | 6393 | 3 | 1.382
102 | 6394 | 6400 | 4 | 1.185
103 | 6401 | 6430 | 3 | 1.382
104 | 6431 | 6431 | 2 | 1.536
105 | 6432 | 6433 | 3 | 1.382
106 | 6434 | 6439 | 2 | 1.536
107 | 6440 | 6441 | 1 | 1.622
108 | 6442 | 6444 | 3 | 1.382
109 | 6445 | 6459 | 4 | 1.185
110 | 6460 | 6467 | 3 | 1.382
111 | 6468 | 6469 | 2 | 1.536
112 | 6470 | 6471 | 3 | 1.382
113 | 6472 | 6474 | 2 | 1.536
114 | 6475 | 6506 | 3 | 1.382
115 | 6507 | 6555 | 2 | 1.536
116 | 6556 | 6573 | 3 | 1.382
117 | 6574 | 6602 | 2 | 1.536
118 | 6603 | 6607 | 3 | 1.382
119 | 6608 | 6641 | 2 | 1.536
120 | 6642 | 6724 | 1 | 1.622
121 | 6725 | 6750 | 2 | 1.536
122 | 6751 | 6797 | 1 | 1.622
123 | 6798 | 6799 | 2 | 1.536
124 | 6800 | 6999 | 3 | 1.382
125 | 7000 | 8999 | 4 | 1.185
126 | 9000 | 9999 | 3 | 1.382