Hi,

I am trying to merge following formulas in a single cell -

=IF(ISNUMBER(A2) + IFERROR(FIND(".com",A2),0) + IFERROR(FIND(".org",A2),0) + IFERROR(FIND(".net",A2),0) + IFERROR(FIND("www.",A2),0) + IFERROR(FIND("com.",A2),0) + IFERROR(FIND("300x250",A2),0) + IFERROR(FIND("728x90",A2),0) + IFERROR(FIND("/",A2),0) + IFERROR(FIND("_",A2),0) + IFERROR(FIND("Android",A2),0) + IFERROR(FIND("ios",A2),0) + IFERROR(FIND("Application",A2),0) + IFERROR(FIND("android",A2),0) + IFERROR(FIND("Ios",A2),0) + IFERROR(FIND("application",A2),0) + IFERROR(FIND("ANDROID",A2),0) + IFERROR(FIND("IOS",A2),0) + IFERROR(FIND("APPLICATION",A2),0) + IFERROR(FIND("300*250",A2),0) + IFERROR(FIND("728*90",A2),0) + IFERROR(FIND("IPHONE",A2),0) + IFERROR(FIND("Iphone",A2),0) + IFERROR(FIND("iphone",A2),0) + IFERROR(FIND("300",A2),0) + IFERROR(FIND("728",A2),0) + IFERROR(FIND("320",A2),0) + IFERROR(FIND("50",A2),0) + IFERROR(FIND(".COM",A2),0) + IFERROR(FIND(".ORG",A2),0) + IFERROR(FIND(".NET",A2),0) + IFERROR(FIND("WWW.",A2),0) + IFERROR(FIND("COM.",A2),0) + IFERROR(FIND("300x250",A2),0) + IFERROR(FIND("728x90",A2),0) + IFERROR(FIND("/",A2),0) + IFERROR(FIND("_",A2),0) + IFERROR(FIND("aNDROID",A2),0) + IFERROR(FIND("iOS",A2),0) + IFERROR(FIND("aPPLICATION",A2),0)> 0,A2,"")

AND

=IFERROR(VLOOKUP(A2,Applist!$B$2:$C$6085, 2, FALSE), "")

but unable to make it perfectly. Would you please help me to solve it.

Here is my google doc link - https://docs.google.com/spreadsheets...GIn8Ndg-c/edit where I am working now. You can check this to get relevant data.

Best,
Rinko.