I'm unable to copy and paste anything into the file so its difficult to explain
Basically my worksheet contains several columns but the ones I'm interested in are as follows
Ireland Field Service Department-investigated no
Ireland - investigated No
Ireland Field investigation Dept.Investigate No
These are some of the scenarios above, basically the Product in Ireland - should contain Ireland/IRELAND, Ireland:.....
Product in Irelad = No should contain all else e.g Ireland Field Service Department- investigated, Ireland - investigated etc
The formula I was using is =IF(OR(LEFT([@[USR_CXP_DPSL]],7)="Ireland",LEFT([@[USR_CXP_DPSL]],8)="Ireland:"),"Yes","No"), but this does not return Product in Ireland = Ireland/IRELAND.
Thanks for any help!