E
E
Eugene2020-11-26 22:23:45
Google Sheets
Eugene, 2020-11-26 22:23:45

What is wrong with using array formulas?

I'm trying to make everything beautiful by combining the array formula with the column name, but an error arrives:
5fbffe53f3eef982559625.jpeg
Without the array formula, the values ​​​​are perfectly checked and parsed from the "reference" tab to cell K6 and below with a simple formula:
=IF(C6=0;""; VLOOKUP(C:C;'справочник'!B:D;3;0))
But the formula I need does not work:

={"Статья";ArrayFormula(IF(offset(C5;1;;numRows)=0;""; VLOOKUP(C5:C;'справочник'!B:D;3;0)))}

Plz tell me the correct solution.

upd: link to spreadsheet

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-11-26
@Coolbeat

Maybe bypassing ARRAYFORMULA should start with C6?
5fc0145f66e6c982170033.png

={"Статья";ARRAYFORMULA(IFERROR(VLOOKUP(C6:C;'Справочник'!B:D;3;0)))}

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question