Looking for help with trying to find a no of key words in a cell and return the key word if found.
=IF(ISERROR(FIND("Half Moon Bay",A1,1)),"Half Moon Bay",IF(ISERROR(FIND("Hornby",A1,1)),"Hornby","")) and so on and so on
Thought the above might have worked but allas my heads done in with a hot stuffy office...
Bookmarks