Retrieve value selected in data validation list onto another cell

[Swati Vishwanathan]

hello Excel gurus

I have created a dropdown list with 10 variables from a list. it works fine. Now i want that the value that is selected by the user should be extracted to another cell. Basically I want to reference that cell for a formula to extract some other value.

Eg. My data validation is on C4. Out of the 10 variables, user selects the option "red", i want the same value "red' in E4, so I can use E4 as locked cell in another formula

I see some VBA codes but would prefer to use excel formulas to achieve this

Regards
Swati

 

[NARAYANK991]

Hi ,

I am not clear on what your requirement is.

Irrespective of whether C4 contains mere data , formula or a data validation dropdown , why can E4 not reference C4 ?

And why should E4 reference C4 so that E4 can be referenced in another formula ? Can that formula not directly reference C4 ?

Lastly , referencing any cell is a simple matter of using a formula such as =celladdress ; shouldn't a formula such as =C4 in any other cell reference C4 ?

Can you clarify ?

Narayan

 

[Swati Vishwanathan]

Thanks Narayan

I see your point and =celladdress just works fine. I was reusing someone workbook and maybe they have used some other method and I am not able to retrieve the cell value there

But on a new worksheet, I can def see that just pointing to cell works

Regards
Swati