Drop down selection formula

[mfairhurst1]

Hi Everyone

I hope you are all well!

I am trying to find a formula which will make a cell say yes or no if a option from a drop down box is selected.

Basically if the account is selected from the drop down box then it will say yes in the active account column. If it is not selected it will say no.

I have tried a number of IF statements but cant get it to work. I have attached the spreadsheet so please feel free to give it a go.

Thanks

Mike

Active Account.xlsx

[DBY]

Hello
Try the following formula in I4:I8:

=IF(D4="","",IF(COUNTIF($D$14:$D$20,D4),"Yes","No"))

Hope this helps.
DBY

[mfairhurst1]

That works. Brilliant. thanks for your help