{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Feuil1","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Ref_A1","INFO_xxxx21"]
["Ref_A18","INFO_xxxx17"]
["Ref_A5","INFO_xxxx24"]
["Ref_A10","INFO_xxxx1"]
["Ref_A22","INFO_xxxx10"]
["Ref_A4","INFO_xxxx15"]
[null,"INFO_xxxx2"]
["Ref_A24","INFO_xxxx6"]
["Ref_A11","INFO_xxxx25"]
[null,"INFO_xxxx12"]
["Ref_A15","INFO_xxxx7"]
["Ref_A25","INFO_xxxx16"]
["Ref_A2","INFO_xxxx5"]
["Ref_A16","INFO_xxxx11"]
[null,"INFO_xxxx23"]
["Ref_A17","INFO_xxxx19"]
["Ref_A20","INFO_xxxx14"]
[null,"INFO_xxxx13"]
["Ref_A6","INFO_xxxx22"]
["Ref_A19","INFO_xxxx8"]
["Ref_A9","INFO_xxxx9"]
[null,"INFO_xxxx4"]
["Ref_A12","INFO_xxxx18"]
["Ref_A21","INFO_xxxx20"]
["Ref_A7","INFO_xxxx3"]

{"sheet":"Feuil2","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A1))),\"\")","v":"Ref_A1"},{"$f":"IFERROR(VLOOKUP(A1,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx21"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A2))),\"\")","v":"Ref_A18"},{"$f":"IFERROR(VLOOKUP(A2,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx17"},null,null,"Feuil1: base de données"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A3))),\"\")","v":"Ref_A5"},{"$f":"IFERROR(VLOOKUP(A3,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx24"},null,null,"Feuil2 édition"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A4))),\"\")","v":"Ref_A10"},{"$f":"IFERROR(VLOOKUP(A4,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx1"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A5))),\"\")","v":"Ref_A22"},{"$f":"IFERROR(VLOOKUP(A5,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx10"},null,null,"édition:"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A6))),\"\")","v":"Ref_A4"},{"$f":"IFERROR(VLOOKUP(A6,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx15"},null,null,"attention, la formule en A est matricielle est doit être entrée avec la touche enter en maintenant les touches crtl et shift enfoncées"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A7))),\"\")","v":"Ref_A24"},{"$f":"IFERROR(VLOOKUP(A7,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx6"},null,null,"elle doit s'afficher automatiquement entre accolades dans la barre de formule"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A8))),\"\")","v":"Ref_A11"},{"$f":"IFERROR(VLOOKUP(A8,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx25"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A9))),\"\")","v":"Ref_A15"},{"$f":"IFERROR(VLOOKUP(A9,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx7"},null,null,"la formule matricielle étant assez gourmande en capacité, bien limiter les champs au nombre de lignes utiles ( formule en A)"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A10))),\"\")","v":"Ref_A25"},{"$f":"IFERROR(VLOOKUP(A10,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx16"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A11))),\"\")","v":"Ref_A2"},{"$f":"IFERROR(VLOOKUP(A11,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx5"},null,null,"le code SIERREUR daen A et B évite les affichages #N/A si valeurs non trouvées"]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A12))),\"\")","v":"Ref_A16"},{"$f":"IFERROR(VLOOKUP(A12,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx11"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A13))),\"\")","v":"Ref_A17"},{"$f":"IFERROR(VLOOKUP(A13,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx19"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A14))),\"\")","v":"Ref_A20"},{"$f":"IFERROR(VLOOKUP(A14,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx14"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A15))),\"\")","v":"Ref_A6"},{"$f":"IFERROR(VLOOKUP(A15,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx22"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A16))),\"\")","v":"Ref_A19"},{"$f":"IFERROR(VLOOKUP(A16,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx8"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A17))),\"\")","v":"Ref_A9"},{"$f":"IFERROR(VLOOKUP(A17,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx9"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A18))),\"\")","v":"Ref_A12"},{"$f":"IFERROR(VLOOKUP(A18,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx18"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A19))),\"\")","v":"Ref_A21"},{"$f":"IFERROR(VLOOKUP(A19,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx20"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A20))),\"\")","v":"Ref_A7"},{"$f":"IFERROR(VLOOKUP(A20,Feuil1!A:B,2,0),\"\")","v":"INFO_xxxx3"}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A21))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A21,Feuil1!A:B,2,0),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A22))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A22,Feuil1!A:B,2,0),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A23))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A23,Feuil1!A:B,2,0),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A24))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A24,Feuil1!A:B,2,0),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Feuil1!$A$1:$A$25,SMALL(IF(Feuil1!$A$1:$A$25<>\"\",ROW($A$1:$A$25)),ROW(A25))),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A25,Feuil1!A:B,2,0),\"\")","v":""}]