Data Validation & Vlookup

[Abhijeet]

Hi
I have data i want Vlookup Formula & Data Validation Dependent List need to use when i select Emergency N P in Cell A1 then C1 cell i want Work 3.5,Work 4.6,Work 7.5 these option i want for select how do this please tell me

 

[udprocks]

Hi
I have data i want Vlookup Formula & Data Validation Dependent List need to use when i select Emergency N P in Cell A1 then C1 cell i want Work 3.5,Work 4.6,Work 7.5 these option i want for select how do this please tell me

Hi Abhijit,

See below link i think this one meet your query, if yes go with this.

www.contextures.com/xlDataVal13.html

 

[Abhijeet]

can u upload in my file

 

[udprocks]

can u upload in my file

hi abhijeet,

it takes some time for me if u want it from my side..

wait till 09:00 PM i will work on it, little bit busy with other works...

 

[Nebu]

Is this what you are looking for ...
you can also go through the following link
http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

 

[Abhijeet]

Hi
I want more if i select basic then no need to data validation dependent list i want enter any value in C1 cell

 

[Nebu]

You have to be more clear with what you want arrange your data in a proper order so that others can understand you requirement clearly...

 

[Abhijeet]

problem is resolved