'Array Formula in just one cell Google Sheets

I have a formula that do almost what I need. I'm trying to get a list of values with a condition depending about one value, is objetive 1 is equal or over to 80 show me the list of objetives equal or over 80. My formula is this one :

=ARRAYFORMULA(IF(('Product Prioritization Matrix'!C7:C >= 80), 'Product Prioritization Matrix'!B7:B,""))

My problem comes when I try to put this in just one cell in the last image will show what I need visualy.

The next images will show the sheets:

enter image description here

My formula

enter image description here

Expected result

enter image description here

Help please

listif-statementgoogle-sheetsarraylist


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions