Spreadsheet: 79070d1279295644-comparing-lists-and-returning-corresponding-values-sample-1
Sheet: - Rev 2

 | - Radiator Schedule | Area (m.sq) | Height | Volume | Watts / Cu.m (watts) |  | Heatloss (watts) | Height | Length | Type | Quantity | Ref | Output |  | Quinn Round Top Radiator | 600high | Double Convector
 | Ground Floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Length | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1600 | 1800 | 2000
 | Staircore 2 | 23.2 | 4.25 | 98.6 | 45 |  | 4437 | 600 | 1800 |  |  |  | 4432 |  | Corrected output | 739 | 985 | 1232 | 1478 | 1724 | 1970 | 2217 | 2463 | 2709 | 2956 | 3202 | 3448 | 3941 | 4432 | 4926
 | Teaching Room 1 | 14 | 4.25 | 59.5 | 45 |  | 2677.5 | 600 |  |  |  |  | #N/A |  | Output catalogue | 583 | 777 | 972 | 1166 | 1360 | 1554 | 1749 | 1943 | 2137 | 2332 | 2526 | 2720 | 3109 | 3497 | 3886
 | Teaching room 2 | 14.2 | 4.25 | 60.34999999999999 | 45 |  | 2715.75 | 600 |  |  |  |  | #N/A
 | Theatre Design Room | 13 | 4.25 | 55.25 | 45 |  | 2486.25 | 600 |  |  |  |  | #N/A
 | Workshop Office | 18.7 | 4.25 | 79.475 | 45 |  | 3576.375 | 600 |  |  |  |  | #N/A |  |  | 300 | 739
 | Practice room 3 | 9.8 | 4.25 | 41.65000000000001 | 45 |  | 1874.25 | 600 |  |  |  |  | #N/A |  |  | 400 | 985
 | Practice room 2 | 9.7 | 4.25 | 41.22499999999999 | 45 |  | 1855.125 | 600 |  |  |  |  | #N/A |  |  | 500 | 1232
 | Practice room 1 | 9.7 | 4.25 | 41.22499999999999 | 45 |  | 1855.125 | 600 |  |  |  |  | #N/A |  |  | 600 | 1478
 | [NAME] store | 7.3 | 4.25 | 31.025 | 45 |  | 1396.125 | 600 |  |  |  |  | #N/A |  |  | 700 | 1724
 | Café counter area | 9.7 | 4.25 | 41.22499999999999 | 45 |  | 1855.125 | 600 |  |  |  |  | #N/A |  |  | 800 | 1970
 | Café dining area | 83.1 | 9.1 | 756.2099999999999 | 45 |  | 34029.45 | 600 |  |  |  |  | #N/A |  |  | 900 | 2217
 | Main corridor 1 | 39.5 | 4.25 | 167.875 | 45 |  | 7554.375 | 600 |  |  |  |  | #N/A |  |  | 1000 | 2463
 | Breakout 1 | incl. | 4.25 | incl. | 45 |  | #N/A | 600 |  |  |  |  | #N/A |  |  | 1100 | 2709
 | Reharsal room 2 | 28 | 4.25 | 119 | 45 |  | 5355 | 600 |  |  |  |  | #N/A |  |  | 1200 | 2956
 | Reharsal room 1 | 28 | 4.25 | 119 | 45 |  | 5355 | 600 |  |  |  |  | #N/A |  |  | 1300 | 3202
 | Pratice room 4 | 10 | 4.25 | 42.5 | 45 |  | 1912.5 | 600 |  |  |  |  | #N/A |  |  | 1400 | 3448
 | Female toilets | 21.4 | 4.25 | 90.94999999999999 | 45 |  | 4092.75 | 600 |  |  |  |  | #N/A |  |  | 1600 | 3941
 | Male toilets | 18.8 | 4.25 | 79.9 | 45 |  | 3595.5 | 600 |  |  |  |  | #N/A |  |  | 1800 | 4432
 | Toilet lobby | 8.3 | 4.25 | 35.27500000000001 | 45 |  | 1587.375 | 600 |  |  |  |  | #N/A |  |  | 2000 | 4926
 | Staircore 1 | 15.4 | 4.25 | 65.45 | 45 |  | 2945.25 | 600 |  |  |  |  | #N/A
 | [NAME] | 10.1 | 4.25 | 42.925 | 45 |  | 1931.625 | 600 |  |  |  |  | #N/A
 | Main entrance | 20.9 | 4.25 | 88.82499999999999 | 45 |  | 3997.125 | 600 |  |  |  |  | #N/A
 | Workshop | 140.3 | 4.25 | 596.2750000000001 | 45 |  | 26832.375 | 600 |  |  |  |  | #N/A
 | Ex. Toilets | 9.5 | 4.25 | 40.375 | 45 |  | 1816.875 | 600 |  |  |  |  | #N/A
 | [NAME] 1 | 9.9 | 4.25 | 42.075 | 45 |  | 1893.375 | 600 |  |  |  |  | #N/A |  | I need to compare cell H4 to the list R8-22 and find the closest match, then return the corresponding number in list Q8-22 to cell j4
 | Studio 1 Backstage | 19.2 | 4.25 | 81.6 | 45 |  | 3672 | 600 |  |  |  |  | #N/A
 | Studio One | 188.5 | 8.56 | 1613.56 | 45 |  | 72610.20000000001 | 600 |  |  |  |  | #N/A
 | First Floor
 | Staircore 2 | 37.5 | 3.3 | 123.75 | 45 |  | 5568.75 | 600
 | Direction | 9.6 | 3.3 | 31.68 | 45 |  | 1425.6 | 600
 | Lighting | 9.2 | 3.3 | 30.36 | 45 |  | 1366.2 | 600
 | Writing | 9.2 | 3.3 | 30.36 | 45 |  | 1366.2 | 600
 | Studio 3 | 50 | 6 | 300 | 45 |  | 13500 | 600
 | Studio 2 | 51.4 | 6 | 308.4 | 45 |  | 13878 | 600
 | Maain corridor 2 | 16.4 | 3.3 | 54.11999999999999 | 45 |  | 2435.4 | 600
 | Wardrobe workshop | 23 | 6 | 138 | 45 |  | 6210 | 600
 | Showers + Lockers | 17.2 | 6 | 103.2 | 45 |  | 4643.999999999999 | 600
 | Studio 2 Store | 5 | 3.3 | 16.5 | 45 |  | 742.5 | 600
 | Tutorial | 4.7 | 3.3 | 15.51 | 45 |  | 697.95 | 600
 | General Office | 21.2 | 6 | 127.2 | 45 |  | 5723.999999999999 | 600
 | [NAME] | 70.7 | 6 | 424.2 | 45 |  | 19089 | 600
 | Rescource Room | 32.4 | 6 | 194.4 | 45 |  | 8747.999999999998 | 600
 | Staff Room | 34.8 | 6 | 208.8 | 45 |  | 9396 | 600
 | Staircore 1 | 24 | 3.3 | 79.19999999999999 | 45 |  | 3564 | 600
 | Artistic directors Office | 26.2 | 3.3 | 86.46 | 45 |  | 3890.7 | 600
 | Studio 1 store 2 | 10.9 | 6 | 65.4 | 45 |  | 2943 | 600
 | [NAME] lobby | 8.4 | 3.3 | 27.72 | 45 |  | 1247.4 | 600
 | Dressing room corridor | 22.4 | 3.3 | 73.91999999999999 | 45 |  | 3326.4 | 600
 | Dressing room 1 | 13 | 3.3 | 42.9 | 45 |  | 1930.5 | 600
 | Dressing room 2 | 14.2 | 3.3 | 46.85999999999999 | 45 |  | 2108.7 | 600
 | Circulation/Toilets | 10.1 | 3.3 | 33.33 | 45 |  | 1499.85 | 600
 | Heat loss
 | Area |  |  | 1085 | sq.m
 | Building volume |  |  | 3255 | cu.m.
 | rough |  |  | 45 | W/sq.m
 | heat |  |  | 146.475 | kW