Trying to compare part of a cell to a column of text.
The above does not work, but I think it gets the intent across. If I replace "Sheet1!B159:B192" with "jim" and E3 contains "Jack Jimbo" I would get a "Yes". I don't want to limit the text to just "Jim" I want to compare each cell in b159 thru b192 ( Which, lets say comma separates cells, may be : "Jack,Jim,Bo,Richard,Chris" )
Does that make sense? If so, Can it be done in Excel 2007? And if so, How?
Code:
=IF(ISNUMBER(SEARCH(Sheet1!B159:B192,E3)),"Yes","No")
The above does not work, but I think it gets the intent across. If I replace "Sheet1!B159:B192" with "jim" and E3 contains "Jack Jimbo" I would get a "Yes". I don't want to limit the text to just "Jim" I want to compare each cell in b159 thru b192 ( Which, lets say comma separates cells, may be : "Jack,Jim,Bo,Richard,Chris" )
Does that make sense? If so, Can it be done in Excel 2007? And if so, How?