GirishDhruva
Active Member
- Joined
- Mar 26, 2019
- Messages
- 308
Hi Everyone,
Check with the above attachment and kindly read the below lines.
In column "D" of Target_Ws i am trying to add the formula, where i need to get the value of that EC based on PEC.
Like below:
If my EC value is 2 based on that i need to get the value of BAS from the Source_Ws sheet and in the similar way i need to get all the other values based on the EC and PEC
Regards,
Dhruva.
Check with the above attachment and kindly read the below lines.
In column "D" of Target_Ws i am trying to add the formula, where i need to get the value of that EC based on PEC.
Like below:
If my EC value is 2 based on that i need to get the value of BAS from the Source_Ws sheet and in the similar way i need to get all the other values based on the EC and PEC
EC | PC | PEC | PEV | PECl |
2 | RP | BAS | 177800 | |
HAR | 88900 | |||
CA | 0 | |||
MA | 0 | |||
CCP | 0 | |||
FVA | 0 | |||
DSR | 0 | |||
PDS | 2200 | |||
VOE | 0 | |||
CPD | 0 | |||
JB | 0 | |||
LET | 0 | |||
SA | 0 | |||
TE | 0 | |||
PFEC | 173216 | |||
VPFC | 442116 | |||
IT | 17780 | |||
PRT | 0 | |||
IS | 117430 | |||
IS Ar | 200 | |||
FCD | 502 | |||
TD | 0 | |||
NP | 2200 |
Regards,
Dhruva.