What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list?
Here's the document.
-
sheet is private - share it– user0Jul 6, 2019 at 9:35
-
Welcome. Please add a brief description of your search/research efforts as is suggested on How to Ask.– Rubén ♦Jul 7, 2019 at 16:25
-
webapps.stackexchange.com/help/someone-answers– user0Jul 7, 2019 at 17:14
Add a comment
|
1 Answer
=ARRAYFORMULA(SUM(HLOOKUP(C1, 'LB dinamic'!A1:H,
{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18}, 0)))
=SUM(INDIRECT("'LB dinamic'!"&
ADDRESS(2, MATCH(C1, 'LB dinamic'!A1:1, 0), 4)&":"&
ADDRESS(ROWS('LB dinamic'!A:A), MATCH(C1, 'LB dinamic'!A1:1, 0), 4)))
=SUMPRODUCT(QUERY(TRANSPOSE('LB dinamic'!A1:M), "where Col1='"&C1&"'", 0))
