What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list?
Here's the document.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityWhat formula I can use in cell C2 to import one column from sheet 2 using a drop-down list?
Here's the document.
=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))