Drop-Down and IF Statement Data Validation in one cell

[gimegg]

Hi everyone,

Here's my problem.
The objective is for people to only be able to touch a cell if a condition is met and they have to select from a list.

Example: people using this excel will only be able to write in cell C2 and choose from a drop-down if B2 = "lalala".
I thought about doing it with Data Validation but with no luck. Is is possible to do it this way or is there someway around it?


I'd gladly appreciate any help you can give me.

Thank you

Gimena

 

[6StringJazzer]

You can use a dynamic dropdown list that is empty if B2 <> "lalala". How is the content of the dropdown list currently defined?

 

[gimegg]

I'm new to Excel so I'm not sure what you mean by dynamic dropdwown list.
My list is just a list of names.

 

[gimegg]

You can use a dynamic dropdown list that is empty if B2 <> "lalala". How is the content of the dropdown list currently defined?

I'm new to Excel so I'm not sure what you mean by dynamic dropdwown list.
My list is just a list of names.

 

[6StringJazzer]

Put the list of names in a worksheet, and use a formula like this for the list:

=IF($B$2="lalala",$F$2:$F$5,$G$2)

F2:F5 contains the list of names
G2 is blank

The list will be empty if B2 is not "lalala".

See linked sample.

Dropbox

www.dropbox.com

 

[gimegg]

Put the list of names in a worksheet, and use a formula like this for the list:

=IF($B$2="lalala",$F$2:$F$5,$G$2)

F2:F5 contains the list of names
G2 is blank

The list will be empty if B2 is not "lalala".

See linked sample.

Dropbox

www.dropbox.com

 

[gimegg]

Thank you it's not working as a data validation.
I think I wasn't clear and I forgot some information. Coming back to the example, I have already a formula in cell C2 which shows the word "FILL" if B2="lalala".
I don't know if that clears is up a bit.

 

[6StringJazzer]

My file is working exactly as what you described. Please explain what you mean by "not working as a data validation." What are you getting and how is it different than what you expect?

Having a formula in C2 should not affect the solution I provided. I updated the file to show that. The file can be accessed at the same link above in post 6.

 

[gimegg]

Yes, I see it works wonderful and that's exactly what I'm looking for but for some reason it doesn't work. Could it be related to the fact the B2 is also a drop-down?

 

[6StringJazzer]

it works wonderful and that's exactly what I'm looking for but for some reason it doesn't work

Well, now I have just have no idea at all what you mean.