If second word x or y then true or else false

[makinmomb]

DADO 20 X 20 = VULCI [ANTICA]

DADO DECOR 20 X 20 = VULCI [ANTICA]

DADO LISTELLO 4.5 X 20 = VULCI [ANTICA] Assume the above on a1 to a3 Formula on b1 to to plug y if second word on stock description is DECOR or LISTELLO expected result , though I need it to leave blank in place of N N Y Y

<colgroup><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Try this formula, copied down.

Excel Workbook
	A	B
1	DADO 20 X 20 = VULCI [ANTICA]
2	DADO DECOR 20 X 20 = VULCI [ANTICA]	Y
3	DADO LISTELLO 4.5 X 20 = VULCI [ANTICA]	Y
Check Words

 

[makinmomb]

Yes peter thanks , seems I don"t have to eat carrots
in compensating reading instead the formula will do the work

Thanks

 

[Rick Rothstein]

Here is another formula that also seems to work...

=IF(OR(LEFT(MID(A1,FIND(" ",A1&" ")+1,9),{6,9})={"DECOR ","LISTELLO "}),"Y","N")

 

[Peter_SSs]

Here is another formula that also seems to work...

=IF(OR(LEFT(MID(A1,FIND(" ",A1&" ")+1,9),{6,9})={"DECOR ","LISTELLO "}),"Y","N")

Rick

A couple of comments.

1. If taking that kind of approach, which does reduce the number of function calls, there is no need for the LEFT function as the two different lengths can be built directly into the MID function instead.

2. Don't know if it is possible with the OP's data, but I've suggested another slight modification to cope in case row 5 is possible.

So, my modified version of this, and also noting the OPs request regarding the 'N' results ...

expected result , though I need it to leave
blank in place of N

N
Y
Y

... becomes as shown in C2 below.

Excel Workbook
	A	B	C
1		Rick	Peter
2	DADO 20 X 20 = VULCI [ANTICA]	N
3	DADO DECOR 20 X 20 = VULCI [ANTICA]	Y	Y
4	DADO LISTELLO 4.5 X 20 = VULCI [ANTICA]	Y	Y
5	DADO LISTELLO	N	Y
Check Words