Get cell data from entire row from another row-CodePudding

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))

CodePudding user response：

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

=FILTER(B1:B15,ISBLANK(A1:A15))

wrong assumption regarding question - but maybe interesting:

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

=FILTER(MAP(A1:A15,LAMBDA(d,CELL("adresse",d))),ISBLANK(A1:A15))