Formula to search small list

[ExcelRoy]

Hi,

I am looking for a formula to search

Update!$EM$3:$EM$52

for the contents of E10, if found return "", otherwise return"#"

hope this makes sense

Thanks for any help

 

[Aladin Akyurek]

Hi,

I am looking for a formula to search

Update!$EM$3:$EM$52

for the contents of E10, if found return "", otherwise return"#"

hope this makes sense

Thanks for any help

Try...

=IF(ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH(E10,$E$3:$EM$52))),"","#")

 

[ExcelRoy]

That's perfect thanks Aladin

 

[Aladin Akyurek]

That's perfect thanks Aladin

You are welcome.

 

[Peter_SSs]

Also
=IF(COUNTIF(Update!$EM$3:$EM$52,"*"&E10&"*"),"","#")