richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
HI guys,
I have an issue with a very importat formula inside my file that is not working.
The issue is this:
I have this data in one sheet:
In another sheet, I have this data:
The issue is this, I need a formula on the right side of this table in order to obtain this result:
The trend is this: On the first number of the first table if exist, the formula has to write the value on the other numbers indie the same cells the formula has to write "Venduto".
I know it is not very simple, and it was not very simple to explain.
It is very important for me, thank you guys.
I have an issue with a very importat formula inside my file that is not working.
The issue is this:
I have this data in one sheet:
| London (Center) Sub 98 - 287 | € 176.700 |
| London (Center) Sub 59 - 204 - 266 | € 240.000 |
| London (Center) Sub 127 - 258 | € 178.900 |
| London (Center) Sub 188 | € 17.900 |
| London (Center) Sub 124 - 261 | € 178.900 |
| London (Center) Sub 283 - 284 | € 32.200 |
| London (Center) Sub 36 - 233 | € 207.400 |
| London (Center) Sub 30 - 254 - 255 | € 317.000 |
| London (Center) Sub 34 - 197 - 282 | € 260.000 |
| Paris (Center) Sub 29 - 154 | € 295.000 |
| Berlin (Center) Sub 28 - 42 | € 145.000 |
| Berlin (Center) Sub 26 - 44 | € 148.000 |
In another sheet, I have this data:
| Berlin (Center) | 9 - 51 |
| Berlin (Center) | 10 - 54 |
| Berlin (Center) | 12 - 53 |
| Berlin (Center) | 24 - 50 |
| Berlin (Center) | 26 - 44 |
| Berlin (Center) | 28 - 42 |
| Berlin (Center) | 57 - 64 |
| Berlin (Center) | 58 - 65 |
| Berlin (Center) | 59 - 66 |
| London (Center) | 98 |
| London (Center) | 287 |
| London (Center) | 59 |
| London (Center) | 204 |
| London (Center) | 266 |
| London (Center) | 127 |
| London (Center) | 258 |
| London (Center) | 185 |
| London (Center) | 186 |
| London (Center) | 101 |
| London (Center) | 188 |
| London (Center) | 124 |
| London (Center) | 261 |
| London (Center) | 36 |
| London (Center) | 233 |
| London (Center) | 284 |
| London (Center) | 283 |
| London (Center) | 30 |
| London (Center) | 254 |
| London (Center) | 255 |
| London (Center) | 34 |
| London (Center) | 197 |
| London (Center) | 206 |
| London (Center) | 282 |
| London (Center) | 259 |
| London (Center) | 279 |
| London (Center) | 280 |
The issue is this, I need a formula on the right side of this table in order to obtain this result:
| Berlin (Center) | 9 - 51 | |
| Berlin (Center) | 10 - 54 | |
| Berlin (Center) | 12 - 53 | |
| Berlin (Center) | 24 - 50 | |
| Berlin (Center) | 26 - 44 | € 148.000 |
| Berlin (Center) | 28 - 42 | € 145.000 |
| Berlin (Center) | 57 - 64 | |
| Berlin (Center) | 58 - 65 | |
| Berlin (Center) | 59 - 66 | |
| London (Center) | 98 | € 176.700 |
| London (Center) | 287 | Venduto |
| London (Center) | 59 | € 240.000 |
| London (Center) | 204 | Venduto |
| London (Center) | 266 | Venduto |
| London (Center) | 127 | € 178.900 |
| London (Center) | 258 | Venduto |
| London (Center) | 185 | |
| London (Center) | 186 | |
| London (Center) | 101 | |
| London (Center) | 188 | € 17.900 |
| London (Center) | 124 | € 178.900 |
| London (Center) | 261 | Venduto |
| London (Center) | 36 | € 207.400 |
| London (Center) | 233 | Venduto |
| London (Center) | 284 | Venduto |
| London (Center) | 283 | € 32.200 |
| London (Center) | 30 | € 317.000 |
| London (Center) | 254 | Venduto |
| London (Center) | 255 | Venduto |
| London (Center) | 34 | € 260.000 |
| London (Center) | 197 | Venduto |
| London (Center) | 206 | |
| London (Center) | 282 | Venduto |
| London (Center) | 259 | |
| London (Center) | 279 | |
| London (Center) | 280 |
The trend is this: On the first number of the first table if exist, the formula has to write the value on the other numbers indie the same cells the formula has to write "Venduto".
I know it is not very simple, and it was not very simple to explain.
It is very important for me, thank you guys.
