Formula to use random number in one field to get value of another field Weighted Lottery

I am creating a weighted lottery for our apartment building to allocate a limited number of bike spaces to the residents. I have tried some weighted lottery spreadsheets that I have found on this website, but it does not seem to be quite so random. It always seems to group certain values together. I have created a spreadsheet (see attached) where each apartment unit is allotted a number of "lottery tickets" based on the percentage of common interest ("%RCI"). There are 95 Units. The value of the Apartment Unit is in Column B (2A, 2B, 2C, etc...). The square footage used to calculate the % RCI is in Column C. Column D is %RCI. Column E represents the number of lottery tickets that unit gets out of a possible 100,000 tickets based on the %RCI. A random number between 0 and 100,000 is in Column H represents the ticket number that is drawn. Columns F-G represent the beginning and end of the range of the ticket numbers for the particular unit based on the number of lottery tickets they get. What I would like to figure out is how to create a formula in column I that says: "If the random number in Column H equals a number that falls in between (including the first and last numbers) of the range Columns F-G in a particular row then the corresponding apartment unit value from that same row appears in I3. For example if "H3" is greater than or equal to "F49" but less than or equal to "G49" then the value in I3 would be the value in "B49", but if H3 is greater than or equal to "F30" but less than or equal to "G30" then the value in I3 would be the value in "B30". Could anyone help me figure out the formula for Column I? Weighted Lottery Based on % of RCI.xlsx

See the workbook at https://app.box.com/s/5a06b6he6sc9ce89bbfl

@ne1ny

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I added your problem as a new tab in the workbook. Same link.

Delete rows for fewer draws, or copy formulas down for additional draws.

You're welcome.