I got a Sales Promotions spreadsheet where I must have a Column which shows the Rows of conflicts of same product being promoted in same dates and different sales representatives.

Columns:

E: Retail Name
F: Sales Representative
L: Product SKU Code
I: Start Date of Promotion
J: End Date of Promotion
M: Sales Chanel (On, Off, On+Off)

=array_constrain((IF(and($E$4:$E<>"";$L$4:$L<>"";$I$4:$I<>"";$J$4:$J<>"";$M$4:$M<>"";$F$4:$F<>"");arrayformula(TEXTJOIN(", ";TRUE;IF(($F1102<>$F$4:$F)($I1102<=$J$4:$J)($J1102>=$I$4:$I)*($L1102=$L$4:$L);IF(ROW($I$4:$I)=ROW();"";"Row"&ROW($I$4:$I));"")));""));COUNTA($E$4:$E);1)

Questions:

1. This formula shows a error “Did Not Find valeu ‘a’ in VLOOKUP evaluation”, which I do not get, once I don’t have VLOOKUP inside the formula. Once I cut of the “($F1102<>$F$4:$F)”, it works just fine.

2. Also the array_constrain is not autofilling the column to the line of last value in Column E.