If, And and ISblank Conditions combined

[ismailzkhan]

Dear Excel Experts,

Please help me in setting up a formula to get desired results. Attached sample Excel file and query.

 

[NARAYANK991]

Hi ,

Try this :

=IF(ISNUMBER(SEARCH("/",A2)),IF(AND(B2="",C2=""),D5,IF(B2<>"",INDEX(J6:J14,MATCH(B2,I6:I14,0)),INDEX(M6:M10,MATCH(C2,L6:L10,0)))),"Slash not found")

Narayan

 

[ismailzkhan]

Dear Narayan Ji,

It works like charm.. Thanks for your help

Regards,
I Khan