Formula to Return non-blank values from a column

[adamb22]

I have seen similar questions w/ responses, but have been unable to modify the solutions to fit my needs.

There is a worksheet with relevant data in columns D and O (other columns don't matter). Where the data in column O acts as a flag and is either blank or populated with "Watch List" depending on two different variables.

I am looking for a formula (non-array) that will return only the non-blank cells in column O with the corresponding value in column D (for the same row). For instance: D2 = A123 and O2 = Watch List, I would like the formula to return A123.

Any help would be greatly appreciated.
Thanks!

[NBVC]

In a new column.. say P2 enter formula:

=IF(O2<>"",COUNT(P$2:P2)+1,"")

copied down

Then to retrieve the data in a new column:

=IFERROR(INDEX(D:D,MATCH(ROWS($A$2:$A2),$P:$P,0)),"")

copied down until you get blanks...

[adamb22]

Thank you very much for you response. Unfortunately, I am not getting the desired result. For the first statement that I placed in column P, I get a circular reference warning (may be okay, just want to confirm that is expected). When I use the 2nd formula, all I receive are zeroes.

I have attached a sample of the data I am using, if this may help. I have hidden all of the rows between D and O.Data Sample.xlsx

Thank you again.

[NBVC]

That formula in P2 should have been:

=IF(O2<>"",COUNT(P$1:P1)+1,"")

copied down.... sorry.

[adamb22]

Worked perfectly! Thanks again.