Forum Discussion

Joshua655's avatar
Joshua655
Copper Contributor
Dec 08, 2023
Solved

Need reccomendations for building a ticket puller for a raffle with Excel.

I have very little understanding in excel so I will go through what i have tried so far. I need my sheet to output 3 different names weighted by ticket amount. I have tried using a =lookup combined ...
excel
Formulas and Functions
office 365
  • LouisDeconinck's avatar
    LouisDeconinck
    Dec 08, 2023

    Joshua655 You were very close, instead of LOOKUP, it's better to use XLOOKUP where we can define the match mode to be "Next larger". Your formula should look like this:

     

     

    =XLOOKUP(RAND(),E2:E7,A2:A7,,1)

     

     

    To make sure each participant can only win one prize, we have to filter the existing dataset as following:

     

     

    =FILTER(A2:C7,A2:A7<>G2)

     

     

    I made a custom video for you, explaining how to build the raffle system step-by-step: https://www.youtube.com/watch?v=gjT_92KZy-E

     

    Optional tip if this was helpful: [link removed by admin]

LouisDeconinck's avatar
LouisDeconinck
Brass Contributor
Dec 08, 2023

Joshua655 You were very close, instead of LOOKUP, it's better to use XLOOKUP where we can define the match mode to be "Next larger". Your formula should look like this:

 

 

=XLOOKUP(RAND(),E2:E7,A2:A7,,1)

 

 

To make sure each participant can only win one prize, we have to filter the existing dataset as following:

 

 

=FILTER(A2:C7,A2:A7<>G2)

 

 

I made a custom video for you, explaining how to build the raffle system step-by-step: https://www.youtube.com/watch?v=gjT_92KZy-E

 

Optional tip if this was helpful: [link removed by admin]

Resources