Hi,
I'm trying to do a "course checker", to find if column D has partial match from a cell at column A, and then give TRUE/FALSE answer next to it on column B.
Column A is a list of courses I have to attend and column D is courses I have done but the fact that they include some extra info makes it harder, at least for me.
I've tried =IF(ISERROR(FIND(A2;D:D;0))=TRUE;FALSE;TRUE) and many other ways with no success.
Bookmarks