Validation List from 2 or more referenced cells

How do I create a validation list that references 2 or more cells on the worksheet?

Example:

A1 = 100 (subject to change upon user input)
C1 = 200 (subject to change upon user input)

I want D1 to contain a Validation List box that contains the items in cells A1 & C1.

Is there any way to do this?

Hi,

Yes ... but not within data validation ...

Create the validation list you need beforehand ...

either with concatenation = A1&C1

or by combining column A and C ...

HTH
Carim

I don't quite follow you, Carim....

How do I combine the columns, and where do I put this validation list?

I'll further explain what I am looking for....

In cell D1, I want a validation list containing the value in cells A1 and C1.
In cell D2, I want a validation list containing the value in cells A2 and C2.
And so on....

Is there a formula that I can put into the SOURCE box that will look up the values in column A and column C and create a validation list box in each cell in column D?

Yowsah...!!!

I figured it out, Carim....!!!

As you suggested, I created a validation list in columns E and F.
Column E = Value in A1...copied down.
Column F = Value in C1...copied down.

Formula in validation source box entered into D1, and copied down:
=$E1:$F1

Then I hid columns E & F.

Works perfectly.....

Glad you fixed your problem

Thanks for the feedback

Carim