I have the following problem:-

I want to see if A1 equals any of B1,B2,B3,B4 or B5 i.e anything from a list, and return with C1 or C2 i.e Yes or No.

If I type in individually B1,B2,B3,B4 or B5 it comes up with the errror "too many arguments".

If I type in the range B1:B5 it doesn't go through the range of cells and only does the IF equation if the cell equals B1, not any of B1,B2,B3,B4 or B5.

The range B1:B5 is a list of text so I can't do a greater than or less than sum.

I hope I'm clear on what I'm trying to get at.

Any help would be greatly appreciated.