CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
The Singularity
The Singularity

Reputation: 2698

Adding Values to a Column in FILTER() on Google Sheets

I'm working with the following Google Sheet.

In the Filter Sheet I used the following FILTER() function to retrieve some data from the Data Sheet.

FILTER({Data!B12:H}, Data!B12:B<>"")

Using the above function I'd like to add a column to the end of the retrieved data containing a value (Lorem Ipsum) in cell A1 of the Data Sheet.

I have tried using the following filter function

FILTER({Data!B12:H,"" &INDEX(Data!A1)}, Data!B12:B<>"")

which yields the error

Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 27. Actual: 1.

My expected output is: enter image description here

Please Advise

Upvotes: 1

Views: 1516

Answers (2)

Aresvik
Aresvik

Reputation: 4630

Try this in cell A5 on the filter sheet:

=arrayformula(FILTER({Data!B12:H,if(Data!B12:B<>"",Data!A1,)}, Data!B12:B<>""))

Upvotes: 2

JPV
JPV

Reputation: 27262

Try

=FILTER({Data!B12:H, IF(LEN(Data!B12:B), Data!A1,)}, Data!B12:B<>"")

and see if that works?

Upvotes: 2

Related Questions