How to get answer if two condition match in two different cells

[devawad]

Hi all,

How to get answer if two condition match in two different cells for example-I want if C1 has text PPSM and C4 has value more than zero for example(1) answer should be PPSM1808040T AND
if C1 has text PABW and C4 has value more than zero for example answer should be PABW1908040T But if C1 has any text but C4 is blank so answer should be blank cell..

I have attached sample file please do the needful friends..


Thanks in advance,

Mahadev.

[Ghozi Alkatiri]

=if(and(isnumber(find("ppsm",c1)),c4>0),"ppsm1808040t",if(and(isnumber(find("ppsm",c4)),c1>0),"pabw1908040t"))

[devawad]

Dear Ghozi Alkatiri,

Thank you so much for your help you have saved lot of manual work you are simply great...

Thanks

Dev