If I had 1000 people who have paid their money to enter a raffle, I would
like to be able to assign a ticket number to each person without having to
write each person's name on each ticket (and ticket stub). I have read
through all Q+As without any luck. Examples of tickets are as follows: Blue
A1, Yellow C32, Red E86 etc. Each ticket book has a maximum of 100 tickets
(eg Blue A1 - Blue A100).

I was intending on using sheet 2 as the entry sheet in which to enter ticket
information ticket colours in column A, ticket letters in Column B, ticket
numbers in Column C and then concatenate them in Column D. On sheet 1, I was
going to enter all peoples names into Column A and have a formula in Column B
that references Column D on sheet 2 and selects a ticket number at random.

What formula should I use to return a randomly selected ticket number?
Thanks in advance.
--
Regards
Matt