datastudent
Board Regular
- Joined
- Sep 7, 2021
- Messages
- 88
- Office Version
- 365
- Platform
- Windows
Hi,
I want to look up the "ACTIVATION" and "DID MRC" value of the Country while considering the Number Type.
Table 1 is a sample source while table 2 is my main table.
I want to look up the "ACTIVATION" and "DID MRC" value of the Country while considering the Number Type.
Table 1 is a sample source while table 2 is my main table.
Template_v1.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
H | I | J | K | L | M | N | O | P | |||
1 | Country | Number type | ACTIVATION | DID MRC | Country | Number type | ACTIVATION | DID MRC | |||
2 | ARGENTINA | Geographic | 0 | 2.91 | AUSTRIA | Geographic | 0 | 0.78 | |||
3 | AUSTRALIA | Geographic | 0 | 1.04 | AUSTRIA | National | 0 | 0.78 | |||
4 | AUSTRIA | Geographic | 0 | 0.78 | AUSTRALIA | Geographic | 0 | 1.04 | |||
5 | AUSTRIA | National | 0 | 0.78 | AUSTRALIA | National | |||||
6 | BELGIUM | Geographic | 0 | 0.32 | BELGIUM | Geographic | 0 | 0.32 | |||
7 | BELGIUM | National | 3.11 | 0.32 | BELGIUM | National | 3.11 | 0.32 | |||
VoxDID |
Cell Formulas | ||
---|---|---|
Range | Formula | |
M3,M7,M5 | M3 | =M2 |