Checking whether a value is one of the items in a list

[sharful]

I Have a list of items in a worksheet, such as:

A1: Apple
A2: Banana
A3: Mango
A4: Grape

Now I need to perform a check (using IF) in another worksheet whether the value of C7 is one of the items mentioned earlier.

I want to do it such way that when I include another item in the list, it will automatically be included in the check.

Is there any way of doing so in Excel? If so, please help.

Thanks in advance.

Sharful

[brokenbiscuits]

=if(COUNTIF(A:A,C7)>0,"YES","NO")

[sharful]

Spot On.

Thank you.