I'm trying to use the TEXTJOIN function to create a comma separated list of the content of each row's Column D value, but only when it's Column J value reads "Regulatory" and it's Column K value reads "No".
I can get it to do this with one condition (i.e. only dependent on Column J OR K), but not both conditions (J AND K). The formula I'm using is:
=TEXTJOIN(",",TRUE,IF('Variable Database'!$J$3:$J$762="Regulatory"*('Variable Database'!$K$3:$K$762="No"),'Variable Database'!$D$3:$D$762,""))
It is a valid formula but just returns "#VALUE". Do you have any ideas about how I might achieve this?
Unable to test this myself (I haven't got TEXTJOIN() unfortunately)
But recently I answered a fairly similar question here
So please try:
{=TEXTJOIN(",",TRUE,IF('Variable Database'!$J$3:$J$762="Regulatory", IF('Variable Database'!$K$3:$K$762="No",'Variable Database'!$D$3:$D$762,""),""))}
Note it's an array formula entered through CtrlShiftEnter