Multiple row / Columns check

Question

Hello Experts,

I have a long data in spreadsheet and below is one of the sample from that. Now what I want the workflow to do is,

1. Check the rows in Col D and find if there is a word "Check". Start and end point for this check would be between Row3/Col C and Row16/Col B, because it contains some digits. These digits could be anywhere on this Columns, but in the sample it is at this position.

2. If the condition in Step 1 is True, then print "X" on Row16/Col D or on Row 16/Col E, whichever is easy.

Col ACol BCol CCol DCol ERow 1     Row 2     Row 3  100.100  Row 4     Row 5     Row 6     Row 7     Row 8     Row 9     Row 10   Check Row 11   CHeck Row 12     Row 13     Row 14     Row 15     Row 16Answer200.125 XX

Any help would be appreciated.

Thanks

Qiu · Answer

@Alteryx_Geek 
Same with @AshRez ,I can not fully understand the logic here either.

Does the value from Col B #3 to Col C#16 matter?

AshRez · Answer

Based on the sample, I would just have a formula and say if there is a value in Column B, then Set value for Col D and E with 'X' 😉

but I guess that is not what you really want, so maybe if you have better samples and clarify why you need it that way, maybe more people can answer it with more intuitive solution.