Forum Discussion
TEXTJOIN formula that incorporates a look up?
Hello All, I have a scenario where for example : I have a list of SKU's for inventory in column A, Column B contains the date the SKU/Product was purchased. Column C lists the Client who purchas...
Hi Andrew,
That could be array formula
=TEXTJOIN(",",TRUE,IF(($B$2:$B$10>=$H2)*($B$2:$B$10<=$I2)*(MATCH($C$2:$C$10,$C$2:$C$10,0)=(ROW($C$2:$C$10)-ROW($C$1))),$C$2:$C$10,""))
assuming you have no empty cells in Clients range.
Attached