Record items appearing in 2 adjacent columns over a given period

[Onebracketshort]

For each row I would like to see if the value in column B appears in either column B or column C at any time over the previous 3 days. If the value appears in the previous 3 days I would like to record the number of the current row in column D.

I would also like to see, for the a each row, if the value in column C appears in either column B or column C at any time over the previous 3 days. If the value appears in the previous 3 days I would like to record the number of the current row in column E.

I have this formula from a previous post

=IF(COUNTIFS(A:A,">="&A10-3,A:A,"<"&A10,C:C,C10),ROW(),"")

I think I need to tweak it to include the additional B column range but excel errors requiring me to provide an additional arguement.

Errors on this formula =IF(COUNTIFS(A:A,">="&A10-3,A:A,"<"&A10,B:B,C:C,C10),ROW(),"")

Any ideas as to where I'm going wrong? Many thanks

Book1
	A	B	C	D	E
1	Date	Item 1	Item 2	Item 1 or Item 2 appears in last 3 days	Item 1 or Item 2 appears in last 3 days
2	01/01/2020	Apple	Pear
3	02/01/2020	Orange	Grape
4	03/01/2020	Pineapple	Bannana
5	04/01/2020	Rasberry	Blackberry
6	05/01/2020	Blueberry	Satsuma
7	06/01/2020	Apple	Pear
8	07/01/2020	Mango	Orange
9	08/01/2020	Melon	Grape
10	09/01/2020	Pineapple	Bannana
11	10/01/2020	Mango	Melon
Sheet1

 

[GlennUK]

If you want to do an OR on the items, add them, like IF((COUNTIFS(etc ... item1)+COUNTIFS(etc ... item2))>0,ROW(),"")