{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["区间查找","倒序查找","横向查找","交叉查找"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"区间查找","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["销量","提成比率","=cz(A12,A1:A7,B1:B7,,,1)"]
[0,"1%","=cz(A12,A1:A7,B1:B7)"]
[300,"2%"]
[500,"3%","第1参数","查找值","可以是逻辑值"]
[1000,"4%","第2参数","查找值所在区域","可以单列、单行，也可多列多行"]
[2000,"5%","第3参数","目标值所在区域","可以单列、单行，在查找值所在区域为多列多行时可使用数字"]
[3000,"6%","第4参数","返回第几个目标值","默认1返回第一个可省略，0代表返回全部，负数代表从最后一个往前返回，-1代表最后一个，-2代表倒数第2个，…………"]
[null,null,"第5参数","是否模糊查找","默认0代表否可省略，1代表常规模糊查找，2代表超级模糊查找"]
[null,null,"第6参数","是否区间查找","默认0代表否可省略，参数为正数时，返回查找值所在区域最接近大于等于查找值对应目标值所在区域的值；参数为负数时，返回查找值所在区域最接近小于等于查找值对应目标值所在区域的值；特别提示：当此参数为非0数字时，查找值所在区域、目标值所在区域只能是单列或单行"]
[]
["销量","向下查找对应提成比率","向上查找对应提成比率"]
[0,{"$f":"cz(A12,$A$1:$A$10,$B$1:$B$10,,,-1)","v":"1%"},{"$f":"cz(A12,$A$1:$A$10,$B$1:$B$10,,,1)","v":"1%"}]
[10,{"$f":"cz(A13,$A$1:$A$10,$B$1:$B$10,,,-1)","v":"1%"},{"$f":"cz(A13,$A$1:$A$10,$B$1:$B$10,,,1)","v":"2%"}]
[290,{"$f":"cz(A14,$A$1:$A$10,$B$1:$B$10,,,-1)","v":"1%"},"2%"]
[300,{"$f":"cz(A15,$A$1:$A$10,$B$1:$B$10,,,-1)","v":"2%"},"2%"]
[301,"2%","3%"]
[499,"2%","3%"]
[500,"3%","3%"]
[501,"3%","4%"]
[999,"3%","4%"]
[1000,"4%","4%"]
[1001,"4%","5%"]
[1999,"4%","5%"]
[2000,"5%","5%"]
[2001,"5%","6%"]
[2999,"5%","6%"]
[3000,"6%","6%"]
[3001,{"$f":"cz(A28,$A$1:$A$10,$B$1:$B$10,,,-1)","v":"6%"},"6%"]
[6000,"6%","6%"]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]

{"sheet":"倒序查找","index":1,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["日期","产品","进货价格","=cz(A12,A1:A7,B1:B7,,,)"]
["2019-04-02","A",100,"=cz(A12,A1:B7,2,,,)"]
["2019-05-06","B",68,"=cz(A12,A1:B7,2)"]
["2019-06-09","A",90,"第1参数","查找值","可以是逻辑值"]
["2019-07-13","B",93,"第2参数","查找值所在区域","可以单列、单行，也可多列多行"]
["2019-08-16","A",87,"第3参数","目标值所在区域","可以单列、单行，在查找值所在区域为多列多行时可使用数字"]
["2019-09-19","B",96,"第4参数","返回第几个目标值","默认1返回第一个可省略，0代表返回全部，负数代表从最后一个往前返回，-1代表最后一个，-2代表倒数第2个，…………"]
[null,null,null,"第5参数","是否模糊查找","默认0代表否可省略，1代表常规模糊查找，2代表超级模糊查找"]
[null,null,null,"第6参数","是否区间查找","默认0代表否可省略，参数为正数时，返回查找值所在区域最接近大于等于查找值对应目标值所在区域的值；参数为负数时，返回查找值所在区域最接近小于等于查找值对应目标值所在区域的值；特别提示：当此参数为非0数字时，查找值所在区域、目标值所在区域只能是单列或单行"]
["产品名称"]
["A"]
["最后一次查找",{"$f":"cz($A$11,$B$1:$C$7,2,-ROW(A1))","v":"87"}]
["倒数第2次查找",{"$f":"cz($A$11,$B$1:$C$7,2,-ROW(A2))","v":"90"}]
["倒数第3次查找","100"]
["倒数第4次查找",""]
[]
["延伸使用方法","列倒序",null,"延伸使用方法","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10"]
[183,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A1))","v":"814"},null,"行倒序",{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A1))","v":"A10"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(B1))","v":"A9"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(C1))","v":"A8"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(D1))","v":"A7"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(E1))","v":"A6"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(F1))","v":"A5"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(G1))","v":"A4"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(H1))","v":"A3"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(I1))","v":"A2"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(J1))","v":"A1"},{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-COLUMN(K1))","v":""}]
[195,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A2))","v":"327"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A2))","v":"A9"}]
[293,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A3))","v":"811"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A3))","v":"A8"}]
[738,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A4))","v":"518"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A4))","v":"A7"}]
[681,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A5))","v":"266"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A5))","v":"A6"}]
[208,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A6))","v":"487"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A6))","v":"A5"}]
[697,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A7))","v":"697"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A7))","v":"A4"}]
[487,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A8))","v":"208"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A8))","v":"A3"}]
[266,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A9))","v":"681"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A9))","v":"A2"}]
[518,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A10))","v":"738"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A10))","v":"A1"}]
[811,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A11))","v":"293"},null,null,{"$f":"cz(TRUE,TRANSPOSE($E$17:$N$17)<>\"\",TRANSPOSE($E$17:$N$17),-ROW(A11))","v":""}]
[327,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A12))","v":"195"},null,"延伸使用方法","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10"]
[814,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A13))","v":"183"},null,"行倒序",{"$f":"cz(OFFSET($E$29,,COUNTA($E$29:$N$29)-ROW(A1),,),$E$29:$N$29,$E$29:$N$29)","v":"A10"},{"$f":"cz(OFFSET($E$29,,COUNTA($E$29:$N$29)-COLUMN(B1),,),$E$29:$N$29,$E$29:$N$29)","v":"A9"},{"$f":"cz(OFFSET($E$29,,COUNTA($E$29:$N$29)-COLUMN(C1),,),$E$29:$N$29,$E$29:$N$29)","v":"A8"},"A7","A6","A5","A4","A3","A2","A1",""]
[null,{"$f":"cz(TRUE,$A$18:$A$30<>\"\",$A$18:$A$30,-ROW(A14))","v":""},null,null,{"$f":"cz(OFFSET($E$29,,COUNTA($E$29:$N$29)-ROW(A2),,),$E$29:$N$29,$E$29:$N$29)","v":"A9"}]
[null,null,null,null,"A8"]
[null,null,null,null,"A7"]
[null,null,null,null,"A6"]
[null,null,null,null,"A5"]
[null,null,null,null,"A4"]
[null,null,null,null,"A3"]
[null,null,null,null,"A2"]
[null,null,null,null,"A1"]
[null,null,null,null,""]

{"sheet":"横向查找","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["语文","物理","数学","化学","=cz(A12,A1:A7,B1:B7,,,)"]
[89,100,33,56,"=cz(A12,A1:B7,2,,,)"]
[null,null,null,null,"=cz(A12,A1:B7,2)"]
[null,null,null,null,"第1参数","查找值","可以是逻辑值"]
[null,null,null,null,"第2参数","查找值所在区域","可以单列、单行，也可多列多行"]
[null,null,null,null,"第3参数","目标值所在区域","可以单列、单行，在查找值所在区域为多列多行时可使用数字"]
["数学",null,null,null,"第4参数","返回第几个目标值","默认1返回第一个可省略，0代表返回全部，负数代表从最后一个往前返回，-1代表最后一个，-2代表倒数第2个，…………"]
[{"$f":"cz(A7,A1:D1,A2:D2)","v":"33"},null,null,null,"第5参数","是否模糊查找","默认0代表否可省略，1代表常规模糊查找，2代表超级模糊查找"]
[null,null,null,null,"第6参数","是否区间查找","默认0代表否可省略，参数为正数时，返回查找值所在区域最接近大于等于查找值对应目标值所在区域的值；参数为负数时，返回查找值所在区域最接近小于等于查找值对应目标值所在区域的值；特别提示：当此参数为非0数字时，查找值所在区域、目标值所在区域只能是单列或单行"]

{"sheet":"交叉查找","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["姓名","语文","物理","数学","化学","=cz(A12,A1:A7,B1:B7,,,)"]
["A1",89,100,33,56,"=cz(A12,A1:B7,2,,,)"]
["A2",71,81,87,81,"=cz(A12,A1:B7,2)"]
["A3",82,98,72,90,"第1参数","查找值","可以是逻辑值"]
["A4",100,78,88,71,"第2参数","查找值所在区域","可以单列、单行，也可多列多行"]
["A5",71,77,93,82,"第3参数","目标值所在区域","可以单列、单行，在查找值所在区域为多列多行时可使用数字"]
["A6",85,88,86,77,"第4参数","返回第几个目标值","默认1返回第一个可省略，0代表返回全部，负数代表从最后一个往前返回，-1代表最后一个，-2代表倒数第2个，…………"]
["A7",90,97,97,86,"第5参数","是否模糊查找","默认0代表否可省略，1代表常规模糊查找，2代表超级模糊查找"]
["A8",77,78,90,92,"第6参数","是否区间查找","默认0代表否可省略，参数为正数时，返回查找值所在区域最接近大于等于查找值对应目标值所在区域的值；参数为负数时，返回查找值所在区域最接近小于等于查找值对应目标值所在区域的值；特别提示：当此参数为非0数字时，查找值所在区域、目标值所在区域只能是单列或单行"]
["A9",91,94,92,84]
[]
[]
["姓名","课程","成绩"]
["A5","数学",{"$f":"cz(A14,$A$1:$E$10,MATCH(B14,$A$1:$E$1,0))","v":"93"}]
["A7","物理",{"$f":"cz(A15,$A$1:$E$10,MATCH(B15,$A$1:$E$1,0))","v":"97"}]