First time opening a topic, hope i am doing this right !
I am trying to recreate a formula from Excel and i seem to be having some trouble.
I saw a similar post in August 2022, but what the user accepted as a solution, does not work for me ( do a Left Outer Join ). I need to see the multiple results from the Lookup separated by comma in each separate cell.
The formula is : =TEXTJOIN(“, “,TRUE,IF(G2=$A$2:$A$7,$B$2:$B$7,””)) , below a screenshot from Excel also.