Forum Discussion
Multiple If formulas with conditions
I am in need a formula that will look at multiple conditions for the data I have. My sample data is below. If the value in A is the same, and the value in B is the same, then join the values ...
*For the future*:
=LET(
row_fields, HSTACK(ID, Company),
GROUPBY(row_fields, Plan, ARRAYTOTEXT, , 0)
)
That formula really has star quality! Both the HSTACK and ARRAYTOTEXT nail it. 
.