chris_streeter
New Member
- Joined
- Apr 10, 2014
- Messages
- 22
Dear all,
I am trying to find a formula that will return a value in the "Value" column in the small table to the right of the larger table. i.e next to cat 1 ref 129 should have a value of 182,500?
Can anyone help?
Thanks
Chris
<tbody>
</tbody>
I am trying to find a formula that will return a value in the "Value" column in the small table to the right of the larger table. i.e next to cat 1 ref 129 should have a value of 182,500?
Can anyone help?
Thanks
Chris
Cat 1 | Cat 1 | Cat 1 | Cat 2 | Cat 2 | Cat 2 | Cat 3 | Cat 3 | Cat 3 | Cat | Ref | Value | ||
Ref | Value | Status | Ref | Value | Status | Ref | Value | Status | |||||
Cat 1 | 129 | ||||||||||||
123 | 247,500 | 1 | 368,000 | 145 | 365,000 | Cat 3 | 258 | ||||||
124 | 186,240 | 2 | 360,000 | 146 | 324,500 | Cat 2 | 16 | ||||||
125 | 189,500 | 3 | 320,000 | 147 | 314,000 | ||||||||
126 | 242,600 | 4 | 320,000 | 148 | 325,000 | ||||||||
127 | 244,500 | 5 | 312,000 | 149 | 348,000 | ||||||||
128 | 236,000 | 6 | 261,000 | 150 | 249,500 | ||||||||
129 | 182,500 | 7 | 305,000 | 151 | 247,500 | ||||||||
130 | 192,000 | 8 | 249,995 | 152 | 259,500 | ||||||||
131 | 275,000 | 9 | 249,995 | 153 | 189,450 | ||||||||
132 | 274,500 | 10 | 255,000 | 154 | 191,500 | ||||||||
133 | 185,000 | 11 | 249,995 | 155 | 264,500 | ||||||||
134 | 249,995 | 12 | 260,000 | 258 | 270,000 | ||||||||
135 | 254,500 | 13 | 264,995 | 259 | 270,000 | ||||||||
136 | 184,400 | 14 | 268,495 | 260 | 270,000 | ||||||||
137 | 229,500 | 15 | 199,875 | 261 | 265,000 | ||||||||
138 | 184,500 | 16 | 239,495 | 262 | 270,000 | ||||||||
139 | 241,500 | 17 | 192,995 | 263 | 270,000 | ||||||||
140 | 274,000 | 18 | 269,697 | 264 | 265,000 | ||||||||
141 | 289,995 | 19 | 266,500 | 265 | 270,000 | ||||||||
142 | 349,995 | 20 | 339,995 | 266 | 270,000 | ||||||||
143 | 299,450 | 21 | 315,900 | 267 | 270,000 | ||||||||
144 | 354,995 | 22 | 339,000 | 268 | 210,000 | ||||||||
156 | 234,495 | 23 | 329,000 | 269 | 242,000 | ||||||||
157 | 189,450 | 24 | 168,550 | 270 | 196,500 | ||||||||
158 | 189,450 | 25 | 346,000 | 271 | 270,000 | ||||||||
159 | 139,500 | 26 | 185,000 | 272 | 160,000 | ||||||||
160 | 234,995 | 27 | 244,500 | 273 | 158,500 | ||||||||
161 | 189,450 | 28 | 200,000 | 274 | 264,500 | ||||||||
162 | 186,500 | 29 | 200,000 | 275 | 192,500 | ||||||||
163 | 186,900 | 30 | 252,000 | 276 | 149,495 | ||||||||
164 | 181,500 | 31 | 250,000 | ||||||||||
165 | 187,000 | 32 | 215,000 | ||||||||||
166 | 241,500 | 33 | 218,000 | ||||||||||
167 | 244,995 | 34 | 205,000 | ||||||||||
168 | 189,500 | 35 | 209,995 | ||||||||||
169 | 192,000 | 36 | 275,000 | ||||||||||
170 | 239,995 | 72 | 217,500 | ||||||||||
171 | 230,000 | 80 | 240,000 | ||||||||||
172 | 234,500 | ||||||||||||
173 | 192,000 | ||||||||||||
174 | 187,220 |
<tbody>
</tbody>