I have a formula =IF(ISNUMBER(SEARCH("Dave",C5)),"ok","not ok") which works fine, my problem is I want to replace "Dave" to the name in Cell A1. Any help would be appreciated.
I have a formula =IF(ISNUMBER(SEARCH("Dave",C5)),"ok","not ok") which works fine, my problem is I want to replace "Dave" to the name in Cell A1. Any help would be appreciated.
will this work?
=IF(ISNUMBER(SEARCH(A1,C5)),"ok","not ok")
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Is that not just:
Formula:=IF(ISNUMBER(SEARCH(A1, C5)),"ok","not ok")
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
My mistake, A1 contains a formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks