Multiple row / Columns check

[Alteryx_Geek]

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 A	Col B	Col C	Col D	Col E
Row 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 16	Answer	200.125		X	X

Any help would be appreciated.

Thanks

[AshRez]

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. 

[Qiu]

@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?