Matching number and color in roulette simulator
I am trying to build an roulette game in Excel. Due to this blog post I am able to randomly select numbers that are provided in column D Spin number. Now I would like to auto-fill E, Spin color based on the columns B Actual Number and C Color.
For example: If D is 17 as in D3 (see below), the formula will look up 17 in B which is B10 and will provide the corresponding Color C10 in E Spin Color in E3. Therefore, 17 in D3 would lead to "Black" in E3.
As I am not very strong in Excel I would appreciate, if someone could provide an answer. Thank you so much!
Edit: With every new run the numbers in column D will change and E has to change accordingly.
Solution
You can do this with VLOOKUP:
=VLOOKUP($D2,$B$2:$C$11,2,false)
or with INDEX / MATCH (which is faster):
=INDEX($C$2:$C$11,MATCH($D2,$B$2:$B$11,0))
- Convert Range to a table
- In Excel, I wonder that how to use VLOOKUP function in OR logic
- Simple VBA array join not working
- Excel Pivot Table - Turn two columns with same values into a matrix pivot table with column names as rows and value count in columns
- Excel: Transforming automatically a cell based on the input in another one
- Check Duplicate Data
- Finding hidden or system files containing ~ using Dir() in VBA
- Deleting rows that do not have specific value (text) - throwing Error Code 13
- Filter function Delivers the Blank cells in the Array as Zeros and Other Blank cells in time formated cells as 12:00
- How to disable Excel's automatic cell reference change after copy/paste?
- Retrieve article name and store of cheapest article for a given category in Excel
- Filter function or alternative for Vertical and Horizontal Criteria
- Calculate SUMPRODUCT with multiple column criteria and one row criteria
- Format smallest value in range of same category in Excel
- Calculate SUMPRODUCT with multiple column criteria and one row criteria (with empty columns in the data range)
- How to group an array of shapes
- Extract text after last delimiter but exclude last character
- How do i calculate difference between counts for each value in Excel
- Highlight cell in a range if the cell value is same as the cell value in a column A
- How to count specific values between other values
- Excel Chart: color data labels by categories - rows
- Get table dynamically with name in excel
- Excel Chart: color data labels by categories - columns
- VBA Error 1004 occurs when manipulating a table
- Store location of cell and loop recursively
- Excel - 3D interpolation
- Excel Data Validation with XLOOKUP
- Using a list (range) of column critiera (not single cells) in FILTER formula
- Yield to maturity / IRR in Power Query M
- How to convert a worksheet to a Data frame in Pandas?