In our day-to-day life, sometimes we face the necessity of inserting random values instead of actual meaningful values. It will take a lot of time and hardship to input those values manually for a huge amount of values. In that case, we can use the **RANDBETWEEN **function and **CHOOSE **function to do this humongous task quite easily. I am going to explain two simple ways to use the** RANDBETWEEN **function with the **CHOOSE** function in Excel in this article. I hope it will be helpful for you if you are looking to generate random values from certain ranges.

**Table of Contents**hide

## Introduction of RANDBETWEEN Function

**RANDBETWEEN function** is a built-in function in Excel that returns a random integer between a bottom and top value. The bottom and top values are inclusive, meaning the returned value can be either the bottom or top value.

__Syntax__

To use the **RANDBETWEEN **function, enter the following into a cell:

**=RANDBETWEEN(bottom, top)**

Replace “bottom” with the lowest integer you want returned and “top” with the highest integer you want returned.

## Basic Concept of CHOOSE Function

The **CHOOSE** function, an Excel built-in function, is within the **Lookup/Reference Function** category. In Excel, it can be used as a worksheet function. **The CHOOSE function** is a worksheet function that can be used as a part of a formula in a worksheet cell.

__Syntax__

The syntax for the **CHOOSE **function is as follows:

**=CHOOSE(index_num, value1, [value2], …)**

**Index_num **means the position of the value to return. **Index_num **must be a number between 1 and 254, or a reference to a cell containing a number between 1 and 254.

**Value1**, **Value2**, … signifies 1 to 254 values from which the function chooses. **Value1 **is chosen when **Index_num **is 1, **Value2 **when **Index_num **is 2, and so on.

__Notes__

If **Index_num **is less than **1**, the **CHOOSE **function returns the **#VALUE! error** value.

If **Index_num **is greater than the number of values in the list, the **CHOOSE **function returns the **#VALUE! error** value.

## Use RANDBETWEEN with CHOOSE Function in Excel:

## 2 Simple Ways

### 1. Extracting Random Data Using RANDBETWEEN with CHOOSE Function

A combination of **RANDBETWEEN **and **CHOOSE **functions can be used to extract a random value from the given options. If we do not need any specific value, we can use this method to extract random values to fill in the required cells.

** Steps**:

- Pick a cell and input the following formula.

`=CHOOSE(RANDBETWEEN(1,3),"10/12/2022","10/16/2022","10/20/2022")`

__Formula Breakdown__

**RANDBETWEEN(1,3)—> **The **RANDBETWEEN **function returns a random value between **1 **to **3**,** Output**: 1

**CHOOSE(1,”10/12/2022″,”10/16/2022″,”10/20/2022″)—> **The **CHOOSE **function returns the first value from the available values.** Output**: 10/12/2022

- Now, press the
**ENTER**button to have the output.

- Finally, use
**Fill Handle**to**AutoFill**the rest cells.

**Related Article:**

### 2. Applying RANDBETWEEN with CHOOSE Function to Generate Value from Certain Cells

If we want some specific values to input randomly, we can certainly apply a formula combining the **RANDBETWEEN **function with **CHOOSE **function. For this purpose, you can follow the following steps.

** Steps**:

- Create a column and enlist some specific cells with values that you want to input randomly.

- Now, select a cell and input the following formula to generate values randomly from the specific cells with values.

`=CHOOSE(RANDBETWEEN(1,3),$E$5,$E$6,$E$7)`

__Formula Breakdown__

**RANDBETWEEN(1,3)—> **The **RANDBETWEEN **function returns a random value between **1 **to **3**,** Output**: 1

**CHOOSE(1,$E$5,$E$6,$E$7)—> **The **CHOOSE **function returns the first value from the first cell of the available cells..** Output**: Protagonist

- Press the
**ENTER**button to generate value from the specified cells.

- Now,
**AutoFill**the rest cells.

Thus, we can easily use the **RANDBETWEEN** and **CHOOSE** functions to do this humongous task.

**Read More: ****How to Apply CHOOSE Function to Create Drop-Down List in Excel**

## Practice Section

For more expertise, you can practice here.

**Download Practice Workbook**

## Conclusion

That’s all for this article. In this article, I have tried to explain two simple ways to** u**se the **RANDBETWEEN** function with the **CHOOSE** function in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.