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?
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Is that not just:
Formula:Please Login or Register to view this content.
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