Excel Help

Copper Contributor
I want a cell with a Data Validation list to populate one of the list options if another cell/series count equals more than “0”(zero).....
6 Replies
Please cite an example of the data and result you want.
Column V: =Countif(G7, “>$0”)
Column W: Data Validation list with 8 options

I want Column W to populate the first option from the list “Opportunity” IF the prior cell is greater than zero.
.... (pls see attached picture if you can as my symbols appear to adjust above once I post this message)


Just for reference, I am only “okay” at Excel so please give me laymen’s instructions if you can :grimacing_face: ty for your help!!
Hello Rikki,
It appears that your attached picture has not been uploaded. Could you try to re-upload your example?
So sorry, I thought it attached. Just loaded as PDF. Please confirm you can view:)
Just to clarify, you would like cell W1 to hold the value "Opportunity" if cell G7 is greater than $0?

@Rikki22bb 

In the attached file, I have 2 sets of formulas for the Source box. The first allows you to select "Opportunity" (if applicable), then Other Options, like this: 

=(IF(V7*(W7=""),Option1,Option2)

The second allows you to select All Options (if applicable); otherwise, it only allows you to select All Other Options, excluding "Opportunity", like this: 

=(IF(V9,Options,Option2)

Note the following names defined in Sheet2: 

NameFormula
Option1=Sheet2!$A$2
Option2=Sheet2!$A$3:$A$9
Options=Sheet2!$A$2:$A$9