richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
Hi Guys,
I need help in order to change the indirect match formula, I have these data to Match.
<tbody>
</tbody>
In the other table, I have these:
<tbody>
</tbody>
I have to take the values from the first table based on the values (Sub and City) of the second one.
Thank you guys,
I need help in order to change the indirect match formula, I have these data to Match.
Values | |
Roma Sub 1 | 85000 |
Pisa Sub 98 - 287 | 176700 |
Pisa Sub 59 - 204 - 266 | 240000 |
Pisa Sub 127 - 258 | 178900 |
Pisa Sub 101-185-186 | 385000 |
Pisa Sub 188 | 17900 |
Pisa Sub 124 - 261 | 178900 |
Pisa Sub 283 - 284 | 32200 |
Pisa Sub 36 - 233 | 207400 |
Pisa Sub 30 - 254 - 255 | 317000 |
Pisa Sub 34 - 197 - 282 | 251800 |
Pisa Sub 94 - 257 | 170000 |
Pisa Sub 90-275 | 191000 |
Pisa Sub 58 - 202 - 203 | 332000 |
Paderno Sub 29 - 154 | 295000 |
Firenze Sub 28 - 42 | 145000 |
Firenze Sub 26 - 44 | 148000 |
<tbody>
</tbody>
In the other table, I have these:
Sub | |
Roma | 1 |
Pisa | 101 |
Pisa | 185 |
Pisa | 186 |
Pisa | 30 |
Pisa | 20 |
Pisa | 10 |
Pisa | 124 |
Pisa | 254 |
Pisa | 255 |
Pisa | 94 |
Pisa | 102 |
Pisa | 103 |
Pisa | 104 |
Pisa | 105 |
Pisa | 106 |
Pisa | 107 |
Pisa | 108 |
Pisa | 109 |
Pisa | 110 |
Pisa | 98 |
Pisa | 287 |
<tbody>
</tbody>
I have to take the values from the first table based on the values (Sub and City) of the second one.
Thank you guys,