Answer the question
In order to leave comments, you need to log in
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:
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)))}
Answer the question
In order to leave comments, you need to log in
Maybe bypassing ARRAYFORMULA should start with C6?
={"Статья";ARRAYFORMULA(IFERROR(VLOOKUP(C6:C;'Справочник'!B:D;3;0)))}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question