|Have you considered the VLOOKUP function with a range_lookup argument of 1?|
That way all you would need to enter is the first number of the buyer's sequence.
Read up on VLOOKUP in the Excel help files to see how the range_lookup argument works.
With the ticket numbers in Column A, sorted ascending, this formula will return Rover if C2 contains any number from 246 though 368:
A B C D
1 Ticket Name Win # Winner
2 123 Fluffy 257 =VLOOKUP(C2,$A$2:$B$4,2,1)
3 246 Rover
4 369 Rusty
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.