Hi All,
I would like to sort the range with two criteria from other sheets. I have created a formula for single sheet but I couldn't do that with Indirect function based on cell value.
=sort('13-Dec-21'!B2:F100,match('13-Dec-21'!E2:E100,{"RED";"Amber";"Green"},0),true,match('13-Dec-21'!D2:D100,{"TR";"IR"},0),true)
Any help would be appreciated. Thanks!
Bookmarks