1

You need to update your Rack Rates data a bit. Add to your "Rack Rates" technical row which will contain key for further mapping - just adding together your variables (i.e. Low2020FALSE). Then Use following formula to get required rate =INDEX('Rack Rates'!$A:$Y, MATCH(P4,'Rack Rates'!$A:$A,0), MATCH(Q4&R4&T4,'Rack Rates'!$A$1:$Y$1,0)) You can ...


1

In Example there is formula ={TRANSPOSE(SPLIT(JOIN(",",ARRAYFORMULA(REPT(transpose(E1:E8)&",", $A$2))), ",")), TRANSPOSE(SPLIT(REPT(JOIN(",",TRANSPOSE(SEQUENCE(A2,1,B2,1)))&",",COUNTA(E1:E8)),","))} First part of formula generates repeating list of clients, where E1:E8 - initial range of clients, $A$2 - cell with number of repeats you need =...


Only top voted, non community-wiki answers of a minimum length are eligible