Get cell data from entire row from another row


I have filtered a row to get cells that are empty and received the column numbers. I want to receive the actual cell data from another column.

Example: A11 is empty. I receive 11 however I want to receive what’s in cell B11.

Here’s what I used: =FILTER(ROW(A1:A15);ISBLANK(A1:A15))

>Solution :

To get the values of column B for rows where A is empty:


wrong assumption regarding question – but maybe interesting:

To retrieve the address of empty cells, you can use this formula:


Leave a Reply Cancel reply