Data validation

[Tornado1981]

I have a cell containing data validation list and what i want to do is that when i choose the 1st value from this list .. a number (for examole 1) appears in another blank cell .. and if i choose the 2nd value from the list .. another number (let's say 2) appears in the blank cell
So how to use the if statement in a cell that contains a data validation ?!!
i need ur help please
thank u

 

[T. Valko]

I have a cell containing data validation list and what i want to do is that when i choose the 1st value from this list .. a number (for examole 1) appears in another blank cell .. and if i choose the 2nd value from the list .. another number (let's say 2) appears in the blank cell
So how to use the if statement in a cell that contains a data validation ?!!
i need ur help please
thank u

See this...

http://contextures.com/xlFunctions02.html

 

[Tornado1981]

sorry .. i didn't catch it
which section exactly is the solution of my problem ?

 

[T. Valko]

sorry .. i didn't catch it
which section exactly is the solution of my problem ?

Try this...

Create a 2 column table. The left column will contain the items that are in your drop down list. The right column contains the value that corresponds to the item. Like this:

Book1
	F	G
1	Item	Value
2	Item1	46
3	Item2	67
4	Item3	7
5	Item4	63
6	Item5	18
7	Item6	5
8	Item7	10
9	Item8	53
10	Item9	27
Sheet1

Now, let's assume cell A1 contains a drop down list that lists the items from the left column of the table.

Enter this formula in B1:

=IF(A1="","",VLOOKUP(A1,F2:G10,2,0))

So, if you select Item5 from the drop down list the formula in B1 will return 18.

 

[Tornado1981]

thank u so much
but what if :
when i choose a value from the list .. a number (e.g 1) appears in a blank cell .. and when i choose another value from the list .. the same number (1) appears in another blank cell ??

 

[T. Valko]

thank u so much
but what if :
when i choose a value from the list .. a number (e.g 1) appears in a blank cell .. and when i choose another value from the list .. the same number (1) appears in another blank cell ??

Sorry, I don't understand what you want to do.

 

[Tornado1981]

Cell A1 contains the drop list

Drop list contains :
Item1
Item2
Item3
Item4
Item5

If i choose Item1 .. in cell C1 appears "1"
If i choose Item2 .. in cell D1 appears also "1"
If i choose Item5 .. in cell G1 appears also "1"

 

[T. Valko]

Cell A1 contains the drop list

Drop list contains :
Item1
Item2
Item3
Item4
Item5

If i choose Item1 .. in cell C1 appears "1"
If i choose Item2 .. in cell D1 appears also "1"
If i choose Item5 .. in cell G1 appears also "1"

You'll need VBA code to do this. I'm not much of a programmer so someone else will need to help you.

Good luck!