I have 3 columns I am trying to write and IF statement for and return a list of values if true for each condition and leave blank if false. I am hoping to get it to look like the format in the screenshot attached. I tried to do something like this in multiple ways but can't get it to work or find anything online to return the values as a list if true for each condition =IF(BC2=Yes,BP, )(BD2=Yes,BC, )(BE2=Yes,Law, )