Iv setup a spreadsheet which contains horse racing results. There are 3 columns with the names of horses.1st, 2nd and 3rd.
I want to put a name of a horse into sheet 2 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