Excel Challenge

Hi, I'll use Excell to sale consert ticket which kolone 1 on sheet1 is ticket number and b is name etc. I use FIND funktion on Sheet2 and use scaning of tickets for finding of the name and ticket no. but i can scan same ticket at several times and i wont  Is it possible to use IF function for fixing this challeng?