Data validation list only when cell is FALSE

L

Legacy 380435

Guest
Hi there,

I am trying to create a drop down list in P4 that only appears if T4 = False.

T4 is dependant on the answer from D4;
=SUMPRODUCT(--ISNUMBER(SEARCH({"Near Miss","Incident"},D4)))>0

P4 needs to display list "Injury" IF T4 shows False. I have it working in essence, but if T4 comes back as TRUE then i am left with a drop down list that's blank, where i would like this cell to be truly blank with no drop down.

In data validation of P4 i have;
=IF(T4=FALSE,Lists!$G$3:$G$19, " ")

I had named "Lists!$G$3:$G$19" to Injury but regardless i am stuck at this junction, will i need VBA to achieve this?

I look forward to any help in advance haha.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,224,837
Messages
6,181,255
Members
453,028
Latest member
letswriteafairytale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top