Home > Software engineering >  Return an array based on Criteria in Google Sheets
Return an array based on Criteria in Google Sheets

Time:08-04

first time posting and looking for some help (please be nice :D)!

I am looking for an array formula to return an array, if the values in a range contain certain text.

For example, in the table below, I have a Lookup range in the left column. I wish to return the values containing "Country", and the end result would be an array with the relevant values, as per the right column. Furthermore, I only want to return the values containing "Country", and not have any blank spaces within the resulting array.

I found this thread: enter image description here

  • Related