joseulloa22
New Member
- Joined
- Dec 28, 2013
- Messages
- 30
am trying to get a formula that searches within a sales order (column A) and tells me if that sales order contains SECT or not (column C).
[TABLE="class: cms_table, width: 339"]
<tbody>[TR]
[TD]SALES ORDER[/TD]
[TD]CUSTOMER[/TD]
[TD]PLANNER[/TD]
[/TR]
[TR]
[TD="align: right"]332456[/TD]
[TD]HOME DEPOT[/TD]
[TD]SECT[/TD]
[/TR]
[TR]
[TD="align: right"]332456[/TD]
[TD]HOME DEPOT[/TD]
[TD]GATE[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]POST[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]GATE[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]HARDWARE[/TD]
[/TR]
[TR]
[TD="align: right"]333980[/TD]
[TD]GIMMICK[/TD]
[TD]HARDWARE[/TD]
[/TR]
[TR]
[TD="align: right"]335790[/TD]
[TD]PARK FENCE[/TD]
[TD]SECT[/TD]
[/TR]
[TR]
[TD="align: right"]335790[/TD]
[TD]PARK FENCE[/TD]
[TD]POST[/TD]
[/TR]
[TR]
[TD="align: right"]336000[/TD]
[TD]HOME DEPOT[/TD]
[TD]HARDWARE[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated
Thanks
Jose Ulloa
[TABLE="class: cms_table, width: 339"]
<tbody>[TR]
[TD]SALES ORDER[/TD]
[TD]CUSTOMER[/TD]
[TD]PLANNER[/TD]
[/TR]
[TR]
[TD="align: right"]332456[/TD]
[TD]HOME DEPOT[/TD]
[TD]SECT[/TD]
[/TR]
[TR]
[TD="align: right"]332456[/TD]
[TD]HOME DEPOT[/TD]
[TD]GATE[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]POST[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]GATE[/TD]
[/TR]
[TR]
[TD="align: right"]332550[/TD]
[TD]THE FENCE MAKER[/TD]
[TD]HARDWARE[/TD]
[/TR]
[TR]
[TD="align: right"]333980[/TD]
[TD]GIMMICK[/TD]
[TD]HARDWARE[/TD]
[/TR]
[TR]
[TD="align: right"]335790[/TD]
[TD]PARK FENCE[/TD]
[TD]SECT[/TD]
[/TR]
[TR]
[TD="align: right"]335790[/TD]
[TD]PARK FENCE[/TD]
[TD]POST[/TD]
[/TR]
[TR]
[TD="align: right"]336000[/TD]
[TD]HOME DEPOT[/TD]
[TD]HARDWARE[/TD]
[/TR]
</tbody>[/TABLE]
Any help is greatly appreciated
Thanks
Jose Ulloa