I want to find out if the contents of a cell are in a predetermined
list. I don't want to have to keep writing an "If" statement for each
entry in the list.

Example:

Array = (Apples, oranges, grapes, bananas}

I want to measure the contents of the cell to determine if they are in
my array. If yes, put a 1, if no put 0. (Will sum 1s later for totals)


I know there's a relatively simple way to do this, but I can't seem to
grasp it right now.

Thanks in advance for any help you can provide!!
Rita