Spreadsheet: 83612d1283575590-vlookup-best-option-to-populate-cells-markshr-ef744450-sdg13
Sheet: TABLES

 |  |  |  | Change cell E3 from a blank cell to TOWN1, then TOWN2. |  |  |  |  |  |  |  | THESE COLUMNS BELOW ARE TO BE ABLE TO CONTINUALLY ADDED
 |  |  |  |  |  |  |  |  |  |  |  | TO WITH NEW TOWNS AND RAINFALL DATA
 |  | TOWN NAME: |  | TOWN1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Today, 12:05 AM
 |  |  |  |  |  |  |  |  |  |  |  |  | TOWN1 |  |  |  |  |  |  |  |  |  | Index Indirect Row Column - Markshr - EF744450 - SDG13.xls
 |  | MIN | 1 Year | 2 years | 5 years | 10 years | 20 years | 50 years | 100 years |  |  |  |  |  |  |  |  |  |  |  |  |  | Registered User   Join Date: 28 Aug 2010
 |  | 5 | 86.3 | 111 | 142 | 161 | 188 | 224 | 253 |  |  |  | 86.3 | 111 | 142 | 161 | 188 | 224 | 253 |  |  |  | Location: Australia
 |  | 6 | 80 | 103 | 132 | 150 | 175 | 209 | 236 |  |  |  | 80 | 103 | 132 | 150 | 175 | 209 | 236 |  |  |  | MS Office Version:Excel 2003
 |  | 10 | 65.6 | 84.6 | 107 | 121 | 141 | 168 | 189 |  |  |  | 65.6 | 84.6 | 107 | 121 | 141 | 168 | 189 |  |  |  | Posts: 9
 |  | 20 | 48.9 | 62.7 | 78.2 | 87.9 | 101 | 120 | 134 |  |  |  | 48.9 | 62.7 | 78.2 | 87.9 | 101 | 120 | 134 |  |  |  | vlookup best option to populate cells?
 |  | 30 | 39.8 | 51 | 63.2 | 70.8 | 81.3 | 95.7 | 107 |  |  |  | 39.8 | 51 | 63.2 | 70.8 | 81.3 | 95.7 | 107 |  |  |  | http://www.excelforum.com/excel-general/744450-vlookup-best-option-to-populate-cells.html
 |  | 60 | 26.3 | 33.6 | 41.5 | 46.3 | 53.1 | 62.3 | 69.6 |  |  |  | 26.3 | 33.6 | 41.5 | 46.3 | 53.1 | 62.3 | 69.6 |  |  |  | After recently learning that excel only allows 7 nested if statements,
 |  | 120 | 16.3 | 20.8 | 25.6 | 28.6 | 32.7 | 38.4 | 42.8 |  |  |  | 16.3 | 20.8 | 25.6 | 28.6 | 32.7 | 38.4 | 42.8 |  |  |  | its my understanding that vlookup is the best option to populate cells based on user input,
 |  | 180 | 12.1 | 15.4 | 19 | 21.1 | 24.2 | 28.4 | 31.7 |  |  |  | 12.1 | 15.4 | 19 | 21.1 | 24.2 | 28.4 | 31.7 |  |  |  | then matching to data.
 |  | 360 | 7.1 | 9.07 | 11.2 | 12.5 | 14.4 | 16.9 | 18.9 |  |  |  | 7.1 | 9.07 | 11.2 | 12.5 | 14.4 | 16.9 | 18.9 |  |  |  | Can anyone help solve my attached problem?
 |  | 720 | 4.17 | 5.36 | 6.7 | 7.54 | 8.7 | 10.3 | 11.6 |  |  |  | 4.17 | 5.36 | 6.7 | 7.54 | 8.7 | 10.3 | 11.6 |  |  |  | Thanks.
 |  | 1440 | 2.44 | 3.17 | 4.08 | 4.66 | 5.45 | 6.55 | 7.44 |  |  |  | 2.44 | 3.17 | 4.08 | 4.66 | 5.45 | 6.55 | 7.44
 |  | 2880 | 1.37 | 1.82 | 2.44 | 2.86 | 3.42 | 4.21 | 4.86 |  |  |  | 1.37 | 1.82 | 2.44 | 2.86 | 3.42 | 4.21 | 4.86
 |  | 4320 | 0.939 | 1.26 | 1.74 | 2.06 | 2.49 | 3.11 | 3.63 |  |  |  | 0.939 | 1.26 | 1.74 | 2.06 | 2.49 | 3.11 | 3.63
 |  |  |  |  |  |  |  |  |  |  |  |  | TOWN2
 |  | Cells E3:F3 are to be for user input of the town name. |  |  |  |  |  |  |  |  |  |  | 92.6 | 119 | 150 | 168 | 194 | 230 | 258
 |  |  |  |  |  |  |  |  |  |  |  |  | 86 | 111 | 139 | 157 | 181 | 214 | 240
 |  | The yellow cells are to be populated by the rainfall data that coresponds with the towns name |  |  |  |  |  |  |  |  |  |  | 70.6 | 90.6 | 113 | 127 | 147 | 173 | 194
 |  |  |  |  |  |  |  |  |  |  |  |  | 52.8 | 67.5 | 83.6 | 93.3 | 107 | 125 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  | 43.2 | 55.1 | 67.9 | 75.6 | 86.3 | 101 | 112
 |  |  |  |  |  |  |  |  |  |  |  |  | 28.6 | 36.4 | 44.7 | 49.7 | 56.7 | 66.2 | 73.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 22.3 | 27.5 | 30.6 | 35 | 41 | 45.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 12.8 | 16.3 | 20.2 | 22.6 | 25.9 | 30.4 | 33.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 7.35 | 9.43 | 11.8 | 13.3 | 15.3 | 18.1 | 20.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4.3 | 5.54 | 7.04 | 7.96 | 9.23 | 11 | 12.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 2.6 | 3.37 | 4.32 | 4.91 | 5.73 | 6.85 | 7.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.56 | 2.04 | 2.64 | 3.02 | 3.54 | 4.26 | 4.84
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.11 | 1.44 | 1.89 | 2.18 | 2.55 | 3.08 | 3.51
 |  |  | Copy the below formula in the [NAME] cell to range [NAME]:J19
 |  |  |  |  | '=IF(ISERROR(INDEX(INDIRECT($E$3),ROW()-6,COLUMN()-3)),"",INDEX(INDIRECT($E$3),ROW()-6,COLUMN()-3))
 |  |  | Highlite the town numbers, and create a range name for the town.
 |  |  | Range Name TOWN1 = Range(N7:T10)
 |  |  | Range Name TOWN2 = Range(N23:T35)