IFS Statement data Validation

Question

Trying to get this function just using data validation.

Answer 1

Select X1 and the values 1, 2, 3 and 4 below it.

On the Formulas tab of the ribbon, in the Defined Names group, click Create from Selection, and click OK in the dialog.

Excel will name the range with 1, 2, 3 and 4 as X1_ (the underscore is because it cannot use X1 - that is a cell address).

Repeat for X2 and the values below it, and for X3 and the values below it.

Then select the cell under B, i.e. cell C8.

On the Data tab of the ribbon, click Data Validation.

Select List from the Allow drop down.

In the Source box, enter the formula

=INDIRECT(B8&"_")

Click OK.

Answer 2

Thank that worked but now my issue is there is no functionality in Office 365 excel

Answer 3

Do you mean Excel Online? If so:

• Select the 1, 2, 3, and 4 below X1.
• Click in the Name box on the left hand side of the Formula bar.
• Type the name X1_ and press Enter.
• Repeat for the other two ranges.

But you may have to create the data validation rule in the desktop version of Excel.

Answer 4

Yes Excel Online I meant

Answer 5

Hello I tried in Excel Online. I was able to make the list, but not able to put it in a Formula in data validation.