Thanks for your reply.
Its not my requirement.
Actually my condition is :
if(CPC_CODE='C4301' and CPC_CODE='C4302','C',
if(CPC_CODE='C4301' and CPC_CODE='C473' and CPC_CODE='C4302' and CPC_CODE='C430' and CPC_CODE='C473'),'D'))))))
Here 'if' condition is not working with 'and' condition.
So i have used match function.Match function is working but not for repetition as told in my previous question.
Pls tell me ,is there any other function or how to sort out this??/
Hi Tresco and Jagan,
Could you tell me how to achieve this with 'and' condition?
because i have cpc_code like
So i have to group them in different pair with 'and' condition.
for cpc_code 4301 and 4302 :- i want name = A , value =30
for cpc_code 4303 and 4304 :- i want name = B , value =70
for cpc_code 4301 - i want name = C , value =10
This is my target.Pls advice.