populating another cell for progress/staus by selection in prior cell's drop down

I have two options for this.

I am tracking status of projects and need a cell to auto populate when one of four (of 8) selections are made from a drop down in a previous cell.
OR
Have the cell auto populate from a cell that is formatted to populate with an "X" when one of those four selections are made.

Other Cell directives further along in the spreadsheet are being driven off of this one cell I need "YES" in, previously just manually entered.

Example:
Drop down in cell D4 has options for: Initiated, Stalled, Moving, Moving Faster, Positive Progress, Wrapping Up, Monkey Wrench, Dead in the Water.
In Cell H4, I am trying to capture the Active Status of "Yes" for Moving, Moving Faster, Positive Progress and Wrapping Up
I have a created visual progress cells which auto populate with X's according to status, so I can use this area as well, if necessary/ease of use, to populate my "Yes" need.

I don't need a No or otherwise in the cell, just the Yes. And the closest I've gotten today is a run-on nest that ehhhhh kind of works, but doesn't seem solid.

Kindly,
Diane

Hi

H4: =CHOOSE(MATCH(D4,{"Initiated","Stalled","Moving","Moving Faster","Positive Progress","Wrapping Up","Monkey Wrench","Dead in the Water"},0),"","","Yes","Yes","Yes","Yes","","")

Rylo

Thanks Rylo. Initially this seems to work (when I enter the formula, it gives the correct response according to selection), however, the formula doesn't show in the cell, nor does it copy down into other cells. ???

Excel 2010, saving as Excel Macro-Enabled Worksheet

Thanks,
Diane

Hi

Put up an example file for review.

rylo