Spreadsheet: 772239d1647102367-named-manager-formula-not-producing-result-sbd-price-list-2022
Sheet: Formulas

=[NAME](
Sizes_Length_1
>=MIN(
Sizes_Column
),
Sizes_Width_1
>=MIN(
Sizes_Row
)),[NAME](
Sizes_Range
,[NAME],INDEX(
Sizes_Column
>=
Sizes_Length_1
,0),0),MATCH(TRUE,INDEX(
Sizes_Row
>=
Sizes_Width_1
,0),0)),""),"")
 | FINAL FORMULA
 | =IF(AND(Sizes_Length_1>=MIN(Sizes_Column),Sizes_Width_1>=MIN(Sizes_Row)),IFERROR(INDEX(Sizes_Range,[NAME],INDEX(Sizes_Column>=Sizes_Length_1,0),0),MATCH(TRUE,INDEX(Sizes_Row>=Sizes_Width_1,0),0)),""),"") | =[NAME]( | Sizes_Length_1 | >=MIN( | Sizes_Column | ), | Sizes_Width_1 | >=MIN( | Sizes_Row | )),[NAME]( | Sizes_Range | ,[NAME],INDEX( | Sizes_Column | >= | Sizes_Length_1 | ,0),0),MATCH(TRUE,INDEX( | Sizes_Row | >= | Sizes_Width_1 | ,0),0)),""),"")
HONEYCOMB OPENVIEW | =IF(AND(mylen_honcomb_opvw_1>=MIN(mycol_honcomb_opvw_moto),mywid_honcomb_opvw_1>=MIN(myrow_honcomb_opvw_moto)),IFERROR(INDEX(myrng_honcomb_opvw_moto,[NAME],INDEX(,MATCH(TRUE,INDEX(>=mylen_honcomb_opvw_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_opvw_moto>=mywid_honcomb_opvw_1,0),0)),""),"") | =[NAME]( | Sizes_Length_1 | >=MIN( | Sizes_Column | ), | Sizes_Width_1 | >=MIN( | Sizes_Row | )),[NAME]( | Sizes_Range | ,[NAME],INDEX( | Sizes_Column | >= | Sizes_Length_1 | ,0),0),MATCH(TRUE,INDEX( | Sizes_Row | >= | Sizes_Width_1 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_opvw_2>=MIN(mycol_honcomb_opvw_moto),mywid_honcomb_opvw_2>=MIN(myrow_honcomb_opvw_moto)),IFERROR(INDEX(myrng_honcomb_opvw_moto,[NAME],INDEX(,MATCH(TRUE,INDEX(>=mylen_honcomb_opvw_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_opvw_moto>=mywid_honcomb_opvw_2,0),0)),""),"") | =[NAME]( | Sizes_Length_1 | >=MIN( | Sizes_Column | ), | Sizes_Width_1 | >=MIN( | Sizes_Row | )),[NAME]( | Sizes_Range | ,[NAME],INDEX( | Sizes_Column | >= | Sizes_Length_1 | ,0),0),MATCH(TRUE,INDEX( | Sizes_Row | >= | Sizes_Width_1 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_opvw_3>=MIN(mycol_honcomb_opvw_moto),mywid_honcomb_opvw_3>=MIN(myrow_honcomb_opvw_moto)),IFERROR(INDEX(myrng_honcomb_opvw_moto,[NAME],INDEX(,MATCH(TRUE,INDEX(>=mylen_honcomb_opvw_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_opvw_moto>=mywid_honcomb_opvw_3,0),0)),""),"") | =[NAME]( | Sizes_Length_1 | >=MIN( | Sizes_Column | ), | Sizes_Width_1 | >=MIN( | Sizes_Row | )),[NAME]( | Sizes_Range | ,[NAME],INDEX( | Sizes_Column | >= | Sizes_Length_1 | ,0),0),MATCH(TRUE,INDEX( | Sizes_Row | >= | Sizes_Width_1 | ,0),0)),""),"")
myrng_honcomb_opvw_moto
mycol_honcomb_opvw_moto
myrow_honcomb_opvw_moto
mylen_honcomb_opvw_1
[NAME]
ZIP ROLLER MAIN | =IF(AND(mylen_zipmain_1>=MIN(mycol_zipmain),mywid_zipmain_1>=MIN(myrow_zipmain)),IFERROR(INDEX(myrng_zipmain,[NAME],INDEX(mycol_zipmain>=mylen_zipmain_1,0),0),MATCH(TRUE,INDEX(myrow_zipmain>=mywid_zipmain_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_zipmain_2>=MIN(mycol_zipmain),mywid_zipmain_2>=MIN(myrow_zipmain)),IFERROR(INDEX(myrng_zipmain,[NAME],INDEX(mycol_zipmain>=mylen_zipmain_2,0),0),MATCH(TRUE,INDEX(myrow_zipmain>=mywid_zipmain_2,0),0)),""),"") | =[NAME]( | mylen_zipmain_2 | >=MIN( | mycol_zipmain | ), | mywid_zipmain_2 | >=MIN( | myrow_zipmain | )),[NAME]( | myrng_zipmain | ,[NAME],INDEX( | mycol_zipmain | >= | mylen_zipmain_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipmain | >= | mywid_zipmain_2 | ,0),0)),""),"")
 | =IF(AND(mylen_zipmain_3>=MIN(mycol_zipmain),mywid_zipmain_3>=MIN(myrow_zipmain)),IFERROR(INDEX(myrng_zipmain,[NAME],INDEX(mycol_zipmain>=mylen_zipmain_3,0),0),MATCH(TRUE,INDEX(myrow_zipmain>=mywid_zipmain_3,0),0)),""),"") | =[NAME]( | mylen_zipmain_3 | >=MIN( | mycol_zipmain | ), | mywid_zipmain_3 | >=MIN( | myrow_zipmain | )),[NAME]( | myrng_zipmain | ,[NAME],INDEX( | mycol_zipmain | >= | mylen_zipmain_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipmain | >= | mywid_zipmain_3 | ,0),0)),""),"")
myrng_zipmain
mycol_zipmain
myrow_zipmain
mylen_zipmain_1
mywid_zipmain_1
ZIP ROLLER BATTERY | =IF(AND(mylen_zipbatt_1>=MIN(mycol_zipbatt),mywid_zipbatt_1>=MIN(myrow_zipbatt)),IFERROR(INDEX(myrng_zipbatt,[NAME],INDEX(mycol_zipbatt>=mylen_zipbatt_1,0),0),MATCH(TRUE,INDEX(myrow_zipbatt>=mywid_zipbatt_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_zipbatt_2>=MIN(mycol_zipbatt),mywid_zipbatt_2>=MIN(myrow_zipbatt)),IFERROR(INDEX(myrng_zipbatt,[NAME],INDEX(mycol_zipbatt>=mylen_zipbatt_2,0),0),MATCH(TRUE,INDEX(myrow_zipbatt>=mywid_zipbatt_2,0),0)),""),"") | =[NAME]( | mylen_zipbatt_2 | >=MIN( | mycol_zipbatt | ), | mywid_zipbatt_2 | >=MIN( | myrow_zipbatt | )),[NAME]( | myrng_zipbatt | ,[NAME],INDEX( | mycol_zipbatt | >= | mylen_zipbatt_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipbatt | >= | mywid_zipbatt_2 | ,0),0)),""),"")
 | =[NAME],[NAME],INDEX(mycol_zipbatt>=mylen_zipbatt_3,0),0),MATCH(TRUE,INDEX(myrow_zipbatt>=mywid_zipbatt_3,0),0)),""),"") | =[NAME]( | mylen_zipbatt_3 | >=MIN( | mycol_zipbatt | ), | mywid_zipbatt_3 | >=MIN( | myrow_zipbatt | )),[NAME]( | myrng_zipbatt | ,[NAME],INDEX( | mycol_zipbatt | >= | mylen_zipbatt_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipbatt | >= | mywid_zipbatt_3 | ,0),0)),""),"")
myrng_zipbatt
mycol_zipbatt
myrow_zipbatt
mylen_zipbatt_1
mywid_zipbatt_1
TWIN ZIP ROLLER MAIN | =[NAME],[NAME],INDEX(mycol_zipmain_twin>=mylen_zipmain_twin_1,0),0),MATCH(TRUE,INDEX(myrow_zipmain_twin>=mywid_zipmain_twin_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_zipmain_twin_2>=MIN(mycol_zipmain_twin),mywid_zipmain_twin_2>=MIN(myrow_zipmain_twin)),IFERROR(INDEX(myrng_zipmain_twin,[NAME],INDEX(mycol_zipmain_twin>=mylen_zipmain_twin_2,0),0),MATCH(TRUE,INDEX(myrow_zipmain_twin>=mywid_zipmain_twin_2,0),0)),""),"") | =[NAME]( | mylen_zipmain_twin_2 | >=MIN( | mycol_zipmain_twin | ), | mywid_zipmain_twin_2 | >=MIN( | myrow_zipmain_twin | )),[NAME]( | myrng_zipmain_twin | ,[NAME],INDEX( | mycol_zipmain_twin | >= | mylen_zipmain_twin_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipmain_twin | >= | mywid_zipmain_twin_2 | ,0),0)),""),"")
 | =[NAME],[NAME],INDEX(mycol_zipmain_twin>=mylen_zipmain_twin_3,0),0),MATCH(TRUE,INDEX(myrow_zipmain_twin>=mywid_zipmain_twin_3,0),0)),""),"") | =[NAME]( | mylen_zipmain_twin_3 | >=MIN( | mycol_zipmain_twin | ), | mywid_zipmain_twin_3 | >=MIN( | myrow_zipmain_twin | )),[NAME]( | myrng_zipmain_twin | ,[NAME],INDEX( | mycol_zipmain_twin | >= | mylen_zipmain_twin_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipmain_twin | >= | mywid_zipmain_twin_3 | ,0),0)),""),"")
myrng_zipmain_twin
mycol_zipmain_twin
myrow_zipmain_twin
mylen_zipmain_twin_1
mywid_zipmain_twin_1
ZIP ROLLER BATTERY_TWIN | =[NAME],[NAME],INDEX(mycol_zipbatt_twin>=mylen_zipbatt_twin_1,0),0),MATCH(TRUE,INDEX(myrow_zipbatt_twin>=mywid_zipbatt_twin_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_zipbatt_twin_2>=MIN(mycol_zipbatt_twin),mywid_zipbatt_twin_2>=MIN(myrow_zipbatt_twin)),IFERROR(INDEX(myrng_zipbatt_twin,[NAME],INDEX(mycol_zipbatt_twin>=mylen_zipbatt_twin_2,0),0),MATCH(TRUE,INDEX(myrow_zipbatt_twin>=mywid_zipbatt_twin_2,0),0)),""),"") | =[NAME]( | mylen_zipbatt_twin_2 | >=MIN( | mycol_zipbatt_twin | ), | mywid_zipbatt_twin_2 | >=MIN( | myrow_zipbatt_twin | )),[NAME]( | myrng_zipbatt_twin | ,[NAME],INDEX( | mycol_zipbatt_twin | >= | mylen_zipbatt_twin_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipbatt_twin | >= | mywid_zipbatt_twin_2 | ,0),0)),""),"")
 | =IF(AND(mylen_zipbatt_twin_3>=MIN(mycol_zipbatt_twin),mywid_zipbatt_twin_3>=MIN(myrow_zipbatt_twin)),IFERROR(INDEX(myrng_zipbatt_twin,[NAME],INDEX(mycol_zipbatt_twin>=mylen_zipbatt_twin_3,0),0),MATCH(TRUE,INDEX(myrow_zipbatt_twin>=mywid_zipbatt_twin_3,0),0)),""),"") | =[NAME]( | mylen_zipbatt_twin_3 | >=MIN( | mycol_zipbatt_twin | ), | mywid_zipbatt_twin_3 | >=MIN( | myrow_zipbatt_twin | )),[NAME]( | myrng_zipbatt_twin | ,[NAME],INDEX( | mycol_zipbatt_twin | >= | mylen_zipbatt_twin_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_zipbatt_twin | >= | mywid_zipbatt_twin_3 | ,0),0)),""),"")
myrng_zipbatt_twin
mycol_zipbatt_twin
myrow_zipbatt_twin
mylen_zipbatt_twin_1
mywid_zipbatt_twin_1
HONEYCOMB | =IF(AND(mylen_honcomb_1>=MIN(mycol_honcomb_moto),mywid_honcomb_1>=MIN(myrow_honcomb_moto)),IFERROR(INDEX(myrng_honcomb_moto,[NAME],INDEX(mycol_honcomb_moto>=mylen_honcomb_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_moto>=mywid_honcomb_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_2>=MIN(mycol_honcomb_moto),mywid_honcomb_2>=MIN(myrow_honcomb_moto)),IFERROR(INDEX(myrng_honcomb_moto,[NAME],[NAME],INDEX(myrow_honcomb_moto>=mywid_honcomb_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_2 | >=MIN( | mycol_honcomb_moto | ), | mywid_honcomb_2 | >=MIN( | myrow_honcomb_moto | )),[NAME]( | myrng_honcomb_moto | ,[NAME],INDEX( | mycol_honcomb_moto | >= | mylen_honcomb_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_moto | >= | mywid_honcomb_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_3>=MIN(mycol_honcomb_moto),mywid_honcomb_3>=MIN(myrow_honcomb_moto)),IFERROR(INDEX(myrng_honcomb_moto,MATCH(TRUE,INDEX(mycol_honcomb_moto>=mylen_honcomb_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_moto>=mywid_honcomb_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_3 | >=MIN( | mycol_honcomb_moto | ), | mywid_honcomb_3 | >=MIN( | myrow_honcomb_moto | )),[NAME]( | myrng_honcomb_moto | ,[NAME],INDEX( | mycol_honcomb_moto | >= | mylen_honcomb_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_moto | >= | mywid_honcomb_3 | ,0),0)),""),"")
myrng_honcomb_moto
mycol_honcomb_moto
myrow_honcomb_moto
[NAME]
mywid_honcomb_1
HONEYCOMB_CRANK | =IF(AND(mylen_honcomb_1>=MIN(mycol_honcomb_crank),mywid_honcomb_1>=MIN(myrow_honcomb_crank)),IFERROR(INDEX(myrng_honcomb_crank,[NAME],INDEX(mycol_honcomb_crank>=mylen_honcomb_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_crank>=mywid_honcomb_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_2>=MIN(mycol_honcomb_crank),mywid_honcomb_2>=MIN(myrow_honcomb_crank)),IFERROR(INDEX(myrng_honcomb_crank,[NAME],INDEX(mycol_honcomb_crank>=mylen_honcomb_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_crank>=mywid_honcomb_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_2 | >=MIN( | mycol_honcomb_crank | ), | mywid_honcomb_2 | >=MIN( | myrow_honcomb_crank | )),[NAME]( | myrng_honcomb_crank | ,[NAME],INDEX( | mycol_honcomb_crank | >= | mylen_honcomb_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_crank | >= | mywid_honcomb_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_3>=MIN(mycol_honcomb_crank),mywid_honcomb_3>=MIN(myrow_honcomb_crank)),IFERROR(INDEX(myrng_honcomb_crank,[NAME],INDEX(mycol_honcomb_crank>=mylen_honcomb_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_crank>=mywid_honcomb_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_3 | >=MIN( | mycol_honcomb_crank | ), | mywid_honcomb_3 | >=MIN( | myrow_honcomb_crank | )),[NAME]( | myrng_honcomb_crank | ,[NAME],INDEX( | mycol_honcomb_crank | >= | mylen_honcomb_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_crank | >= | mywid_honcomb_3 | ,0),0)),""),"")
myrng_honcomb_crank
mycol_honcomb_crank
myrow_honcomb_crank
[NAME]
mywid_honcomb_1
HONEYCOMB_WAND | =IF(AND(mylen_honcomb_1>=MIN(mycol_honcomb_wand),mywid_honcomb_1>=MIN(myrow_honcomb_wand)),IFERROR(INDEX(myrng_honcomb_wand,[NAME],INDEX(mycol_honcomb_wand>=mylen_honcomb_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_wand>=mywid_honcomb_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_2>=MIN(mycol_honcomb_wand),mywid_honcomb_2>=MIN(myrow_honcomb_wand)),IFERROR(INDEX(myrng_honcomb_wand,[NAME],INDEX(mycol_honcomb_wand>=mylen_honcomb_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_wand>=mywid_honcomb_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_2 | >=MIN( | mycol_honcomb_wand | ), | mywid_honcomb_2 | >=MIN( | myrow_honcomb_wand | )),[NAME]( | myrng_honcomb_wand | ,[NAME],INDEX( | mycol_honcomb_wand | >= | mylen_honcomb_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_wand | >= | mywid_honcomb_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_3>=MIN(mycol_honcomb_wand),mywid_honcomb_3>=MIN(myrow_honcomb_wand)),IFERROR(INDEX(myrng_honcomb_wand,[NAME],INDEX(mycol_honcomb_wand>=mylen_honcomb_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_wand>=mywid_honcomb_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_3 | >=MIN( | mycol_honcomb_wand | ), | mywid_honcomb_3 | >=MIN( | myrow_honcomb_wand | )),[NAME]( | myrng_honcomb_wand | ,[NAME],INDEX( | mycol_honcomb_wand | >= | mylen_honcomb_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_wand | >= | mywid_honcomb_3 | ,0),0)),""),"")
myrng_honcomb_wand
mycol_honcomb_wand
myrow_honcomb_wand
[NAME]
mywid_honcomb_1
HONEYCOMB_TWIN_ | =IF(AND(mylen_honcomb_twin_1>=MIN(mycol_honcomb_twin_moto),mywid_honcomb_twin_1>=MIN(myrow_honcomb_twin_moto)),IFERROR(INDEX(myrng_honcomb_twin_moto,[NAME],INDEX(mycol_honcomb_twin_moto>=mylen_honcomb_twin_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_moto>=mywid_honcomb_twin_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_2>=MIN(mycol_honcomb_twin_moto),mywid_honcomb_twin_2>=MIN(myrow_honcomb_twin_moto)),IFERROR(INDEX(myrng_honcomb_twin_moto,[NAME],INDEX(mycol_honcomb_twin_moto>=mylen_honcomb_twin_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_moto>=mywid_honcomb_twin_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_2 | >=MIN( | mycol_honcomb_twin_moto | ), | mywid_honcomb_twin_2 | >=MIN( | myrow_honcomb_twin_moto | )),[NAME]( | myrng_honcomb_twin_moto | ,[NAME],INDEX( | mycol_honcomb_twin_moto | >= | mylen_honcomb_twin_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_moto | >= | mywid_honcomb_twin_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_3>=MIN(mycol_honcomb_twin_moto),mywid_honcomb_twin_3>=MIN(myrow_honcomb_twin_moto)),IFERROR(INDEX(myrng_honcomb_twin_moto,[NAME],INDEX(mycol_honcomb_twin_moto>=mylen_honcomb_twin_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_moto>=mywid_honcomb_twin_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_3 | >=MIN( | mycol_honcomb_twin_moto | ), | mywid_honcomb_twin_3 | >=MIN( | myrow_honcomb_twin_moto | )),[NAME]( | myrng_honcomb_twin_moto | ,[NAME],INDEX( | mycol_honcomb_twin_moto | >= | mylen_honcomb_twin_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_moto | >= | mywid_honcomb_twin_3 | ,0),0)),""),"")
myrng_honcomb_twin_moto
mycol_honcomb_twin_moto
myrow_honcomb_twin_moto
[NAME]
[NAME]
HONEYCOMB_TWIN_CRANK | =IF(AND(mylen_honcomb_twin_1>=MIN(mycol_honcomb_twin_crank),mywid_honcomb_twin_1>=MIN(myrow_honcomb_twin_crank)),IFERROR(INDEX(myrng_honcomb_twin_crank,[NAME],INDEX(mycol_honcomb_twin_crank>=mylen_honcomb_twin_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_crank>=mywid_honcomb_twin_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_2>=MIN(mycol_honcomb_twin_crank),mywid_honcomb_twin_2>=MIN(myrow_honcomb_twin_crank)),IFERROR(INDEX(myrng_honcomb_twin_crank,[NAME],INDEX(mycol_honcomb_twin_crank>=mylen_honcomb_twin_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_crank>=mywid_honcomb_twin_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_2 | >=MIN( | mycol_honcomb_twin_crank | ), | mywid_honcomb_twin_2 | >=MIN( | myrow_honcomb_twin_crank | )),[NAME]( | myrng_honcomb_twin_crank | ,[NAME],INDEX( | mycol_honcomb_twin_crank | >= | mylen_honcomb_twin_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_crank | >= | mywid_honcomb_twin_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_3>=MIN(mycol_honcomb_twin_crank),mywid_honcomb_twin_3>=MIN(myrow_honcomb_twin_crank)),IFERROR(INDEX(myrng_honcomb_twin_crank,[NAME],INDEX(mycol_honcomb_twin_crank>=mylen_honcomb_twin_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_crank>=mywid_honcomb_twin_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_3 | >=MIN( | mycol_honcomb_twin_crank | ), | mywid_honcomb_twin_3 | >=MIN( | myrow_honcomb_twin_crank | )),[NAME]( | myrng_honcomb_twin_crank | ,[NAME],INDEX( | mycol_honcomb_twin_crank | >= | mylen_honcomb_twin_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_crank | >= | mywid_honcomb_twin_3 | ,0),0)),""),"")
myrng_honcomb_twin_crank
mycol_honcomb_twin_crank
myrow_honcomb_twin_crank
[NAME]
[NAME]
HONEYCOMB_TWIN_WAND | =IF(AND(mylen_honcomb_twin_1>=MIN(mycol_honcomb_twin_wand),mywid_honcomb_twin_1>=MIN(myrow_honcomb_twin_wand)),IFERROR(INDEX(myrng_honcomb_twin_wand,[NAME],INDEX(mycol_honcomb_twin_wand>=mylen_honcomb_twin_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_wand>=mywid_honcomb_twin_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_2>=MIN(mycol_honcomb_twin_wand),mywid_honcomb_twin_2>=MIN(myrow_honcomb_twin_wand)),IFERROR(INDEX(myrng_honcomb_twin_wand,[NAME],INDEX(mycol_honcomb_twin_wand>=mylen_honcomb_twin_2,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_wand>=mywid_honcomb_twin_2,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_2 | >=MIN( | mycol_honcomb_twin_wand | ), | mywid_honcomb_twin_2 | >=MIN( | myrow_honcomb_twin_wand | )),[NAME]( | myrng_honcomb_twin_wand | ,[NAME],INDEX( | mycol_honcomb_twin_wand | >= | mylen_honcomb_twin_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_wand | >= | mywid_honcomb_twin_2 | ,0),0)),""),"")
 | =IF(AND(mylen_honcomb_twin_3>=MIN(mycol_honcomb_twin_wand),mywid_honcomb_twin_3>=MIN(myrow_honcomb_twin_wand)),IFERROR(INDEX(myrng_honcomb_twin_wand,[NAME],INDEX(mycol_honcomb_twin_wand>=mylen_honcomb_twin_3,0),0),MATCH(TRUE,INDEX(myrow_honcomb_twin_wand>=mywid_honcomb_twin_3,0),0)),""),"") | =[NAME]( | mylen_honcomb_twin_3 | >=MIN( | mycol_honcomb_twin_wand | ), | mywid_honcomb_twin_3 | >=MIN( | myrow_honcomb_twin_wand | )),[NAME]( | myrng_honcomb_twin_wand | ,[NAME],INDEX( | mycol_honcomb_twin_wand | >= | mylen_honcomb_twin_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_honcomb_twin_wand | >= | mywid_honcomb_twin_3 | ,0),0)),""),"")
myrng_honcomb_twin_wand
mycol_honcomb_twin_wand
myrow_honcomb_twin_wand
[NAME]
[NAME]
SKYFIT_MANUAL | =IF(AND(mylen_skyman_1>=MIN(mycol_skyman),mywid_skyman_1>=MIN(myrow_skyman)),IFERROR(INDEX(myrng_skyman,[NAME],INDEX(mycol_skyman>=mylen_skyman_1,0),0),MATCH(TRUE,INDEX(myrow_skyman>=mywid_skyman_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_skyman_2>=MIN(mycol_skyman),mywid_skyman_2>=MIN(myrow_skyman)),IFERROR(INDEX(myrng_skyman,[NAME],INDEX(mycol_skyman>=mylen_skyman_2,0),0),MATCH(TRUE,INDEX(myrow_skyman>=mywid_skyman_2,0),0)),""),"") | =[NAME]( | mylen_skyman_2 | >=MIN( | mycol_skyman | ), | mywid_skyman_2 | >=MIN( | myrow_skyman | )),[NAME]( | myrng_skyman | ,[NAME],INDEX( | mycol_skyman | >= | mylen_skyman_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_skyman | >= | mywid_skyman_2 | ,0),0)),""),"")
 | =IF(AND(mylen_skyman_3>=MIN(mycol_skyman),mywid_skyman_3>=MIN(myrow_skyman)),IFERROR(INDEX(myrng_skyman,[NAME],INDEX(mycol_skyman>=mylen_skyman_3,0),0),MATCH(TRUE,INDEX(myrow_skyman>=mywid_skyman_3,0),0)),""),"") | =[NAME]( | mylen_skyman_3 | >=MIN( | mycol_skyman | ), | mywid_skyman_3 | >=MIN( | myrow_skyman | )),[NAME]( | myrng_skyman | ,[NAME],INDEX( | mycol_skyman | >= | mylen_skyman_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_skyman | >= | mywid_skyman_3 | ,0),0)),""),"")
myrng_skyman
mycol_skyman
myrow_skyman
mylen_skyman_1
mywid_skyman_1
SKYFIT_MOTORISED | =IF(AND(mylen_skymoto_1>=MIN(mycol_skymoto),mywid_skymoto_1>=MIN(myrow_skymoto)),IFERROR(INDEX(myrng_skymoto,MATCH(TRUE,INDEX(mycol_skymoto>=mylen_skymoto_1,0),0),MATCH(TRUE,INDEX(myrow_skymoto>=mywid_skymoto_1,0),0)),""),"") | =[NAME]( |  | >=MIN( |  | ), |  | >=MIN( |  | )),[NAME]( |  | ,[NAME],INDEX( |  | >= |  | ,0),0),MATCH(TRUE,INDEX( |  | >= |  | ,0),0)),""),"")
 | =IF(AND(mylen_skymoto_2>=MIN(mycol_skymoto),mywid_skymoto_2>=MIN(myrow_skymoto)),IFERROR(INDEX(myrng_skymoto,[NAME],INDEX(mycol_skymoto>=mylen_skymoto_2,0),0),MATCH(TRUE,INDEX(myrow_skymoto>=mywid_skymoto_2,0),0)),""),"") | =[NAME]( | mylen_skymoto_2 | >=MIN( | mycol_skymoto | ), | mywid_skymoto_2 | >=MIN( | myrow_skymoto | )),[NAME]( | myrng_skymoto | ,[NAME],INDEX( | mycol_skymoto | >= | mylen_skymoto_2 | ,0),0),MATCH(TRUE,INDEX( | myrow_skymoto | >= | mywid_skymoto_2 | ,0),0)),""),"")
 | =IF(AND(mylen_skymoto_3>=MIN(mycol_skymoto),mywid_skymoto_3>=MIN(myrow_skymoto)),IFERROR(INDEX(myrng_skymoto,[NAME],INDEX(mycol_skymoto>=mylen_skymoto_3,0),0),MATCH(TRUE,INDEX(myrow_skymoto>=mywid_skymoto_3,0),0)),""),"") | =[NAME]( | mylen_skymoto_3 | >=MIN( | mycol_skymoto | ), | mywid_skymoto_3 | >=MIN( | myrow_skymoto | )),[NAME]( | myrng_skymoto | ,[NAME],INDEX( | mycol_skymoto | >= | mylen_skymoto_3 | ,0),0),MATCH(TRUE,INDEX( | myrow_skymoto | >= | mywid_skymoto_3 | ,0),0)),""),"")
myrng_skymoto
mycol_skymoto
myrow_skymoto
mylen_skymoto_1
mywid_skymoto_1