search criteria like small(if(isnumber(find.. with any code

[Adeel1]

Hi All

i have attached the sheet with made up sample.
in sheet 4 there is column C and E is the data which i received and i want result of column D and F as i mentioned with reference to subject of this post!

column C and E is linked with sheet 3 columns, there is mainly two types of packages here "PRO" and "Control" in column E if its not mention which one package it is than it will look off column D cell to determined that this will pro or control. means E2 has only "freedom" it will look to D2 to determent for its Pro or control , its pro as per D2 & correct result is in F2!

[FONT=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif]if sheet 2 columns D is empty than "sms only" will appear along with all data if it has any of cell e mail address than it will not appear.[/FONT]
[FONT=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif]you may find sample WBK from below link![/FONT]

Also posted: https://www.excelforum.com/excel-pr...ike-small-if-isnumber-find-with-any-code.html

Adeel

 

[Adeel1]

here is link of sample file

https://www.dropbox.com/s/j7tmtnof3mr9mi6/CUG Detail - Copy.xlsm?dl=0
Adeel

 

[Adeel1]

could any one look of my issue please! will be greatfull!

Adeel