B10 = 'High"
=SORT(CONCATENATE(B10,"!B3:", B10, "!AK42"), High!AL3:High!AL42, TRUE)
That returns the error
SORT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 40, column count: 1.
=SORT(High!B3:High!AK42, High!AL3:High!AL42, TRUE)
Works without any problems. Is there an easier way to achieve what I'm doing, or can I make this work with some changes? I'm essentially trying to get a sorted array (B3:AK42 sorted by AL3:AL42) from a sheet (High) specified in a cell (B10).