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 and not numbers so I can't use a greather than or less than sum.
I hope I'm clear on what I'm trying to get at.
Any help would be greatly appreciated.
Bookmarks