How to Make Electronic Raffle Draw in Excel (2 Ways)

To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many participants. But this process becomes easier if we do an electronic raffle draw. If we take the help of Microsoft Excel in this regard, this process becomes simpler and more effortless. In this article, we will show you how to make an electronic raffle draw in Excel.


Download Practice Workbook

You can download the free Excel workbook here and practice on your own.


2 Easy Ways to Make Electronic Raffle Draw in Excel

In our article, you will see two different methods to make an electronic raffle draw in Excel. We will nest the RANDBETWEEN function with the INDEX function in our first method. As for our second approach, we will combine the INDEX function with the MATCH function to make an electronic raffle draw. For our two procedures, we will use the following data set.

Easy Ways to Make Electronic Raffle Draw in Excel

1. Nesting RANDBETWEEN Function with INDEX Function to Make an Electronic Raffle Draw

In our first approach, we will nest the RANDBETWEEN function with the INDEX function for our working purpose. First, the RANDBETWEEN function will generate a random number from the data set. Then the INDEX function will show the value that is fixed for that random number. For a better understanding, follow the following steps.

Step 1:

  • Firstly, we will use the following data set for our procedure.

Easy Ways to Make Electronic Raffle Draw in Excel

Step 2:

  • Secondly, insert the following nested formula in cell C16 to see the winner.
=INDEX(C5:C14,RANDBETWEEN(1,10))

Easy Ways to Make Electronic Raffle Draw in Excel

Formula Breakdown

  • RANDBETWEEN(1,10): Firstly, The RANDBETWEEN function will generate a random number from 1 to 10. As we have 10 entries in our data set, it will take 1 as the lower limit and 10 as the upper limit.
  • INDEX(C5:C14,RANDBETWEEN(1,10)): Then, the INDEX function will show the name that is fixed for the randomly selected number.

Step 3:

  • Thirdly, press Enter and you will see a winner’s name randomly selected by applying the above functions.

Easy Ways to Make Electronic Raffle Draw in Excel

Step 4:

  • Furthermore, by pressing F9 on the keyboard, you can automatically generate more names.

Easy Ways to Make Electronic Raffle Draw in Excel

Read More: How to Randomly Select a Winner in Excel (2 Easy Ways)


Similar Readings


2. Combining INDEX and MATCH Functions to Make an Electronic Raffle Draw in Excel

In our second method, we will combine the INDEX function and the MATCH function to make electronic raffle draw. This method will also include the use of the MAX function and the MIN function of Excel. This method is applicable if you have a set of values assigned to each raffle holder and want to decide the winner based on those values.

2.1 Draw the Maximum Value from Raffle

In this section, we will take the maximum value from the data set to choose the winner. For that purpose, we will insert the MAX function in the combination formula of the INDEX function and the MATCH function. To do that, go through the following steps.

Step 1:

  • Firstly, take the data set and make an extra table to announce the winner.

Easy Ways to Make Electronic Raffle Draw in Excel

Step 2:

  • Secondly, write the following formula in cell C16 to determine the winner.
=INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0))

Easy Ways to Make Electronic Raffle Draw in Excel

Formula Breakdown

  • MAX(D5:D14): The MAX function will find the maximum value from the cell range D5:D14.
  • MATCH(MAX(D5:D14),D5:D14,0): Then the MATCH function will search for the location of that maximum value and it will find an exact match.
  • INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the maximum value.

Step 3:

  • Thirdly, hit the Enter button to get the desired result which is Draco.
  • Consequently, the result will be based upon the lottery number with the highest value in it.

Sample Data Set

2.2 Draw the Minimum Value from Raffle

If you want to decide the winner based on the minimum value from the list, then this procedure will help you to do that. We will apply the MIN function in the combined formula to see the result. The detailed steps for this procedure are below.

Step 1:

  • In the beginning, type the following formula to see the winner in cell C16.
=INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0))

Sample Data Set

Formula Breakdown

  • MIN(D5:D14): The MIN function will search for the minimum value in the cell range D5:D14.
  • MATCH(MIN(D5:D14),D5:D14,0): Then, the MIN function will find the location of that minimum value and it will find an exact match.
  • INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the minimum value.

Step 2:

  • Secondly, the name of the winner will appear after pressing the Enter button.
  • In our example, the winner is Ginny who holds the lowest value of the lottery number.

Sample Data Set

Read More: Random Selection Based on Criteria in Excel (3 Cases)


Conclusion

That’s the end of this article. We hope you find this article helpful. After reading the above description, you will be able to make an electronic raffle draw in Excel automatically by using any of the above-described methods. Please share any further queries or recommendations with us in the comments section below. The Exceldemy team is always concerned about your preferences.


Related Articles

Araf

Araf

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo