Hi,
in the attached spreadsheet I have a search and a data sheet. In the search sheet the user puts in a 4 digit code in B2to see if is exists in the "data" sheet. I want to formula on the search sheet in B3 to give a Yes or No answer if the code is there or not. The problem is that in some instances there my be 2 codes in the 1 cell seperated by a "/" but the user will only be entering 1 of these codes.
Thanks in advance
Bookmarks