Comparing sheet 1 and 2 formula help

[simonbck]

Iv setup a spreadsheet which contains horse racing results. There are 3 columns (E2-E300, G2 - G300 & I2 - I300 with the names of horses.1st, 2nd and 3rd.
I want to put a name of a horse into sheet 2 A1 - A300 and i want it to be able to tell me if the name appears on sheet 1. please can you help with the formula?

Thanks

simon (Excel Beginner)

 

[NBVC]

Try:

=IF(OR(COUNTIF(Sheet1!$E$2:$E$300,A1),COUNTIF(Sheet1!$G$2:$G$300,A1),COUNTIF(Sheet1!$I$2:$I$300,A1)),"Present","Not Present")

or probably even, just:

=IF(COUNTIF(Sheet1!$E$2:$I$300,A1),"Present","Not Present")

If the columns between won't contain the horse's name anyways....