Data Validation to reflect a value used in a formula

[Ouliana]

Hey guys and gals. (i am new to this, so don't judge)

So here is my question...

I am using data validation list setting for a drop down menu (referencing the list in another sheet) - what i want to happen is if one f the values is selected it would generate a value correlated to that... that value has to be used in the formula...

I was trying to use IF formula (as i have more then one value..), define name and INDIRECT but i wasnt able to get it to work...

Also, I need to combine the values selected from the drop down list selection and inputted numbers that will be used in the generation f the values..

I know i am doing terrible job explaining such a simple function I am trying to accomplish, but i hope it makes any sense to you guys

thanks in advance for any help.


Here is an example

One 1
Two 2
Three 3

so if I select "one" from the drop down menu - say cell A2 will insert in the formula =A1+1
if I select "two" - cell A2 would be =A1+2
.. etc.

 

[FDibbins]

If I understand you correctly, then if your data looks something like this...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][/tr]
[tr][td]

1​

[/td][td]

10​

[/td][td]

11​

[/td][td]One[/td][td]One[/td][td]

1​

[/td][/tr]

[tr][td]

2​

[/td][td][/td][td][/td][td][/td][td]Two[/td][td]

2​

[/td][/tr]

[tr][td]

3​

[/td][td][/td][td][/td][td][/td][td]Three[/td][td]

3​

[/td][/tr]
[/table]

C1=your DD
B1=A1+VLOOKUP(C1,$D$1:$E$3,2,0)
D1:E3= your data table

 

[L. Howard]

Hi Ouliana,

I may not have a full grasp on where you are going with this, but here a shot at what I think you want.

Drop down in D1 with text values one, two, three etc. (Refers to the list in column Q.)
Formula in E1 =VLOOKUP(D1,Q1:R5,2,0) --adjust table_array to fit the two columns as you would want with additional values.
Formula in A2 =A1+E1

Select a text value in D1, and see results in A2.


Column Q1 - Q?
one
two
three
four
five
etc.

Column R1 -R?
1
2
3
4
5
etc.

Columns Q & R could be way off screen if needed.

Howard