Ifblank do nothing otherwise do something

[pgrad]

Hi All,

Im struggling with what I think shoud be a straight forward problem.

In one sheet I have a list of phone numbers and in another sheet a list of employees and where they have a phone number this is shown, if not the correspoding cell is blank.

I have this formula to check if an employees number is listed

=IF(COUNTIF(Mobiles!E2:E2542,K:K),"Yes","No")

I would like to ignore cells which are blank and have come up with this but its not working.

=IF(ISBLANK(K2),"",(IF(K2="*",COUNTIF(Mobiles!E2:E2542,K2)"Yes","No"))"")

Any advice would be fantastic

Thanks
Paul

 

[AlphaFrog]

Try something like this...
=IF(K2="","",IF(COUNTIF(Mobiles!E2:E2542,K2),"Yes","No"))

 

[pgrad]

Thanks very much, works perfectly!

Have a great day!