Return unique values based on another column's value

Hi,

Please see attached.

In column F I have values YES or NO, and in column A, I have a list of other values - from row 1 to 20.

I want to see the 4 values in column H because the value in column F is yes. There will always be 6 rows (in this test data) and I'd like if possible the values in column H to update automatically if the value in column F changes (ie : from yes to no)

Is this possible?

Thanks in advance.