[stewartd14]

I am trying to make a horses to follow list on MS Excel. I am importing an A-Z of runners into the document and trying to do a match up formula if you know what I mean. e.g. IF(A1=sheet2!A5,"YES","") or something like that. However due to there being over 200 horses most days what I want to know is: Instead of doing a formula for IF A1=A2,A3,A4,A5. Is there an OR formula I can use to work out if a cell equals any of the cells in a large range. Help much appreciated as I dont want to type out this long list of 200 or 300 cells with commas. I tried doing this with dragging down through the range but I assume this checks if the 1 cell equals all of the selected cells. I hope you understand and I appreciate any help from the computer geniuses on here. Thanks