I found this:
link
and it seems to be nearly what I need, but does not work.
I'm looking for a way to have a cell search a column for text, exact text, such as "ITEM", "FORM", "TREE", etc. and if it's found in the column then the cell in question simply displays an X. If not leave the cell blank.
Here's what I'm doing:
Column A is a list of ~300 key words.
Column B, C, D etc are templates (Ford, Chevy, Dodge, etc) that needs to have an X next to those items that they have for a side by side comparison purpose.
I can pull a list of items (in text only) each template has, so I want to be able to paste these items into a column further to the right. So for this example I'll put Ford's list of items into E, Chevy into F, Dodge into G.
I think this was almost there:
=IF(E:E= A3, "X", "")
TIA
Bookmarks