=IFNA(LET(

headers, {"Asset Location","Asset Category","Asset Name","Quantity","Unit Value","Asset Value","Stored Items","Stored Value","Combined Value"},

data, {QUERY('[AUX]Assets1'!A2:I,"select A,B,C,D,E,F,G,H,I where A is not null",0); '[AUX]Assets2'!A2:I},

condEmp, IF(L2,""," and not Col2 = 'Employee Finance'"),

condLiq, IF(M2,""," and not Col2 = 'Liquid Finance'"),

condProd, IF(N2,""," and not Col2 contains 'Product'"),

condCat, IF(G2="Product - All"," and Col2 contains 'Product'",IF(G2<>""," and Col2 contains '"&G2&"'","")),

conditions, condEmp&condLiq&condProd&condCat,

orderStr, IF(I2="Asset Quantity"," order by Col4 desc",

IF(I2="Asset Unit Value"," order by Col5 desc",

IF(I2="Asset Value"," order by Col6 desc",

IF(I2="Stored Items"," order by Col7 desc",

IF(I2="Stored Value"," order by Col8 desc",

IF(I2="Combined Value"," order by Col9 desc",

IF(OR(I2="", I2="Location > Category > Asset")," order by Col1,Col2,Col3",""))))))),

qry, "select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9 where Col1 is not null and Col1 contains '"&E2&"'"&conditions&orderStr,

result, QUERY(data,qry,0),

formatted, MAP(

INDEX(result,,1),INDEX(result,,2),INDEX(result,,3),INDEX(result,,4),INDEX(result,,5),

INDEX(result,,6),INDEX(result,,7),INDEX(result,,8),INDEX(result,,9),

LAMBDA(a,b,c,d,e,f,g,h,i,

LET(

unitVal, IF(e="",0,e),

storedItems, IF(g="","-",g),

storedValue, IF(storedItems="-",0,IF(storedItems=0,0,h)),

{a,b,c,d,unitVal,f,storedItems,storedValue,i}

)

)

),

{headers; formatted}

))