+ Reply to Thread
Results 1 to 3 of 3

Trying to make a database type thing

  1. #1
    Registered User
    Join Date
    05-04-2016
    Location
    Isle of Wight, England
    MS-Off Ver
    2016
    Posts
    2

    Question Trying to make a database type thing

    So, I'm a YouTuber and I'm adding a reward thing. Basically, 1 lucky person who subscribes to me wins a prize. I'm trying to make it automated, so in a cell next to all the subscribers I have:
    =RANDBETWEEN(1,10)
    Because there's 10 example subscribers.
    Now, here's the part I'm not sure about.
    I want it to print the user that is that random number. I've tried this:

    =TEXT(AC6,"is the winner!")
    But it doesn't work. What I want to make it do is print the A value of C6.
    Is this possible? Can anyone help? Thanks!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Trying to make a database type thing

    Hi Knightz and welcome to the forum,

    This looks like an Index Match type of problem to me. You would get the Match row in your RandBetween column and Index that into your Names Column.

    Read about Index-Match at: http://www.contextures.com/xlFunctions03.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-04-2016
    Location
    Isle of Wight, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Trying to make a database type thing

    Thanks! Fixed it by adding this:
    =INDEX(A1:$A$10,C6)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 3-Dimensional looking graph, how to make such thing?
    By BornUltimate in forum Excel General
    Replies: 1
    Last Post: 02-05-2016, 05:08 PM
  2. [SOLVED] Modify the Code to Make It Do the Same Thing for More Columns
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-24-2014, 02:12 PM
  3. [SOLVED] If cell contains text do one thing, if it contains number do another thing
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2013, 11:50 AM
  4. how to make the COUNTIF function stop searching after it finds 1 thing
    By Jona2491 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2013, 07:38 PM
  5. Excel calendar search macro - type thing
    By ksatoday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 06:26 AM
  6. Replies: 5
    Last Post: 02-25-2010, 12:43 PM
  7. Make excel think txt and csv are same thing
    By rich1876 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1