I have a task list of things that need to be done on RMA's.
what I want to do is have a cell where the user inputs a model number or
description (perhaps 6 choices), then the cells that don't apply to that part
number would display an N/A

=IF(SEARCH("SS", C6, 1)0, "N/A", " ") works only for words containing ss,
anything else creates an error.

=IF(C6="SS", "N/A", " ") works only if the input is ss

Any help would be greatly appreciated.

Thanks.