Results 1 to 2 of 2

Thread: Formula help with drawing random cards

  1. #1

    Formula help with drawing random cards



    Register for a FREE account, and/
    or Log in to avoid these ads!

    So I hope this makes sense. I am creating a "board game" type game in excel and one of the functions will be landing on a cell. When you are on this cell you click the checkbox to the left of it which then flips the value to true. I then have another formula generating a random number between 1 and 100 if the value is true. I would like to make cards in a separate sheet out of single cells but make about 40-50 of them maybe less. I want it to be able to pull a card(cell's) contents into another cell on another sheet. But I want it to be a random card associated with the random number generator. I can definitely make changes if this isn't possible but the point of it is to show the contents of one of the random cards.

  2. #2
    If I understand correctly you could associate a number with each of the cards and then call it with a lookup like =vlookup(randbetween(1,100),Sheet2!A:B,2,false).

    Hope this helps,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •