{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["例1 普通查找","例2 从右查左","例3 上下查","例4 多条件查","例5 查找第2个值","例6 查最后一个","例7 一对多查找","例8 区间查找","例9 筛选","对比","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"例1 普通查找","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["姓名","数学","语文"]
["张飞",100,89]
["李玉清",68,66]
["吴一几",100,75]
["张大遇",93,70]
["刘能",87,69]
["王飞",96,82]
[]
[]
["姓名","语文","CZ","Mlookup","其他替代"]
["吴一几",{"$f":"Wlookup(A11,A2:A7,C2:C7)","v":75},{"$f":"CZ(A11,A2:C7,3,1)","v":75},{"$f":"Mlookup(A11,A2:C7,3,1)","v":75},"Lookup,Vlookup"]

{"sheet":"例2 从右查左","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["学号","姓名","数学","语文"]
["A001","张飞",100,89]
["A002","李玉清",68,66]
["A003","吴一几",100,75]
["A004","张大遇",93,70]
["A005","刘能",87,69]
["A006","王飞",96,82]
[]
[]
["姓名","学号","CZ","Mlookup","其他替代"]
["吴一几",{"$f":"Wlookup(A11,B2:B7,A2:A7)","v":"A003"},{"$f":"CZ(A11,B1:B7,A1:A7)","v":"A003"},null,"Index+Match,Lookup数组公式,Vlookup数组公式"]

{"sheet":"例3 上下查","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["语文","物理","数学","化学"]
[89,100,33,56]
[]
[]
[null,"数学","CZ","Mlookup","其他替代"]
[null,{"$f":"Wlookup(B5,A1:D1,A2:D2)","v":33},{"$f":"CZ(B5,A1:D1,A2:D2)","v":33},null,"Hlookup"]

{"sheet":"例4 多条件查","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["学号","姓名","数学","语文"]
["A001","张飞",100,89]
["A002","李玉清",68,66]
["A003","吴一几",100,75]
["A004","张大遇",93,70]
["A005","刘能",87,69]
["A006","王飞",96,82]
[]
[]
["学号","姓名","语文","CZ","Mlookup","其他替代"]
["A005","刘能",{"$f":"Wlookup(A11&B11,A2:A7&B2:B7,D2:D7)","v":69},{"$f":"CZ(A11&B11,A1:A7&B1:B7,D1:D7)","v":69},{"$f":"Mlookup(A11:B11,A2:D7,4,1)","v":69},"Lookup,Vlookup"]

{"sheet":"例5 查找第2个值","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["日期","产品","进货价格"]
["2019-04-02","A",100]
["2019-05-06","B",68]
["2019-06-09","A",90]
["2019-07-13","B",93]
["2019-08-16","A",87]
["2019-09-19","B",96]
[]
[]
["产品名称","第2次进货价格","CZ","Mlookup"]
["A",{"$f":"Wlookup(A11,B2:B7,C2:C7,2)","v":90},{"$f":"CZ(A11,B2:C7,2,2)","v":90},{"$f":"Mlookup(A11,B2:C7,2,2)","v":90}]

{"sheet":"例6 查最后一个","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["日期","产品","进货价格"]
["2019-04-02","A",100]
["2019-05-06","B",68]
["2019-06-09","A",90]
["2019-07-13","B",93]
["2019-08-16","A",87]
["2019-09-19","B",96]
[]
[]
["产品名称","最后一次进货价格","CZ","Mlookup"]
["A",{"$f":"Wlookup(A11,B2:B7,C2:C7,0)","v":87},{"$f":"CZ(A11,B1:B7,C1:C7,-1)","v":87},{"$f":"Mlookup(A11,B2:C7,2,0)","v":87}]

{"sheet":"例7 一对多查找","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["日期","产品","进货价格"]
["2019-04-02","A",100]
["2019-05-06","B",68]
["2019-06-09","A",90]
["2019-07-13","B",93]
["2019-08-16","A",87]
["2019-09-19","B",96]
[]
[]
["产品名称","所有进货价格","CZ","Mlookup","其他替代"]
["A",{"$f":"Wlookup(A11,B2:B7,C2:C7,-1)","v":"100,90,87"},{"$f":"CZ(A11,B2:C7,2,0)","v":"100,90,87"},{"$f":"Mlookup(A11,B2:C7,2,-1)","v":"100,90,87"}]

{"sheet":"例8 区间查找","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["销量","提成比率"]
[0,0.01]
[300,0.02]
[500,0.03]
[1000,0.05]
[2000,0.06]
[3000,7.0000000000000007E-2]
[]
[]
["销量","提成比率","CZ","Mlookup","其他替代"]
[600,{"$f":"Wlookup(A11,A2:A7,B2:B7,-2)","v":0.03},{"$f":"CZ(A11,A1:A7,B1:B7,,,-1)","v":0.03},null,"Lookup,Vlookup"]

{"sheet":"例9 筛选","index":8,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["日期","产品","进货价格"]
["2019-04-02","A",100]
["2019-05-06","B",68]
["2019-06-09","A",90]
["2019-07-13","B",93]
["2019-08-16","A",87]
["2019-09-19","B",96]
[]
[]
["产品名称"]
["B"]
[]
["日期","产品","进货价格","CZ",null,"Mlookup"]
[{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,A$2:A$7,ROW(A1)),\"\")","v":"2019-05-06"},null,{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,C$2:C$7,ROW(A1)),\"\")","v":68},{"$f":"IFERROR(CZ($A$11,$B$2:$B$7,$A$2:$A$7,ROW(A1)),\"\")","v":"2019/5/6"},{"$f":"IFERROR(CZ($A$11,$B$2:$C$7,2,ROW(A1)),\"\")","v":68},null,{"$f":"IFERROR(Mlookup($A$11,$B$2:$C$7,2,ROW(A1)),\"\")","v":68}]
[{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,A$2:A$7,ROW(A2)),\"\")","v":"2019-07-13"},{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,B$2:B$7,ROW(B2)),\"\")","v":""},{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,C$2:C$7,ROW(A2)),\"\")","v":93},{"$f":"IFERROR(CZ($A$11,$B$2:$B$7,$A$2:$A$7,ROW(A2)),\"\")","v":"2019/7/13"},{"$f":"IFERROR(CZ($A$11,$B$2:$C$7,2,ROW(A2)),\"\")","v":93},null,{"$f":"IFERROR(Mlookup($A$11,$B$2:$C$7,2,ROW(A2)),\"\")","v":93}]
["2019-09-19",{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,B$2:B$7,ROW(B3)),\"\")","v":""},{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,C$2:C$7,ROW(A3)),\"\")","v":96},"2019/9/19",96,null,{"$f":"IFERROR(Mlookup($A$11,$B$2:$C$7,2,ROW(A3)),\"\")","v":96}]
["",{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,B$2:B$7,ROW(B4)),\"\")","v":""},"","","",null,""]
["",{"$f":"IFERROR(Wlookup($A$11,$B$2:$B$7,B$2:B$7,ROW(B5)),\"\")","v":""},"","","",null,""]

{"sheet":"对比","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["查找的应用场景","CZ","MLOOKUP","WLOOKUP","其他函数"]
["普通查找","★★★★★","★★★★★","★★★★★","LOOKUP、VLOOKUP"]
["逆向查（从右查左）","★★★★★",null,"★★★★★","INDEX+MATCH、VLOOKUP数组公式"]
["上下查","★★★★★",null,"★★★★★","HLOOKUP"]
["多条件查","★★★","★★★★★","★★★","LOOKUP"]
["查找第2个值","★★★★★","★★★★★","★★★★★"]
["查最后一个","★★★★★","★★★★★","★★★★★"]
["一对多查找","★★★★★","★★★★★","★★★★★","VLOOKUP、INDEX+SMALL+ROW"]
["区间查找","★★★★★","★★★★★","★★★★★","LOOKUP、VLOOKUP"]
["筛选","★★★★★","★★★","★★★★★","INDEX+SMALL+ROW、VLOOKUP+辅助列"]
["深度模糊查找","★★★★★",null,"★★★"]

{"sheet":"Sheet2","index":10,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
["省份","用户数"]
["广东省",226283]
["上海",11066]
["北京",99963]
["江苏省",84561]
["浙江省",65278]
["山东省",57936]
["河南省",48548]