{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,2,23,2],[21,1,23,1],[25,2,28,2],[26,1,28,1],[30,2,33,2],[31,1,33,1]]}
["A2","cette cellule reçoit la valeur cherchée, elle ne contient pas de formule et peut être effacée"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"un double clic sur les cellules, de D26 à D35 renvoie sur la cellule correspondante de la Feuil3"]
[]
[null,"pour adaptation  du code, voir clic droit sur onglet et \"visualiser le code\""]
[]
[null,"note: dans le champ actif, un double clic sur une cellule vide renvoie en B1 de feuil3"]
[]
[]
[]
[]
[null,"ESSAI1","NON","ABC1",50,24]
[null,{"$f":"IF(E21=0,\"\",(\"8:00\"-SUM(N21:N24))/\"8:00\")","v":1},null,"QSD1",50,24]
[null,null,null,"ABC22",50,24]
[null,null,null,"aaaaaa",50,24]
[]
[{"$f":"IFERROR(MATCH(\"*\"&$B$26&\"*\",OFFSET([1]Final!$G$1,SUM($A$25:A25)+1,0,1000,1),0),\"\")","v":""},"ESSAI2","OUI","A1"]
[{"$f":"IFERROR(MATCH(\"*\"&$B$26&\"*\",OFFSET([1]Final!$G$1,SUM($A$25:A26)+1,0,1000,1),0),\"\")","v":""},{"$f":"IF(E26=0,\"\",(\"8:00\"-SUM(N26:N29))/\"8:00\")","v":""},null,"A2"]
[{"$f":"IFERROR(MATCH(\"*\"&$B$26&\"*\",OFFSET([1]Final!$G$1,SUM($A$25:A27)+1,0,1000,1),0),\"\")","v":""},null,null,"A3"]
[{"$f":"IFERROR(MATCH(\"*\"&$B$26&\"*\",OFFSET([1]Final!$G$1,SUM($A$25:A28)+1,0,1000,1),0),\"\")","v":""},null,null,"A4"]
[]
[{"$f":"IFERROR(MATCH(\"*\"&$B$31&\"*\",OFFSET([1]Final!$G$1,SUM($A$30:A30)+1,0,1000,1),0),\"\")","v":""},"ESSAI3","NON","B1",null,27]
[{"$f":"IFERROR(MATCH(\"*\"&$B$31&\"*\",OFFSET([1]Final!$G$1,SUM($A$30:A31)+1,0,1000,1),0),\"\")","v":""},{"$f":"IF(E31=0,\"\",(\"8:00\"-SUM(N31:N34))/\"8:00\")","v":""},null,"B2",null,27]
[{"$f":"IFERROR(MATCH(\"*\"&$B$31&\"*\",OFFSET([1]Final!$G$1,SUM($A$30:A32)+1,0,1000,1),0),\"\")","v":""},null,null,"B3",null,27]
[{"$f":"IFERROR(MATCH(\"*\"&$B$31&\"*\",OFFSET([1]Final!$G$1,SUM($A$30:A33)+1,0,1000,1),0),\"\")","v":""},null,null,"B4",null,27]

{"sheet":"Feuil2","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Ref","Description"]
[null,"A1","AAA bbb 24*45g ",null,null,null,"<ESSAI1 - Appart>"]
[null,"A2","AAAA BBB 20*300g ",null,null,null,"<ESSAI2 - Appart>"]
[null,"A3","AAA bb 12*220g P",null,null,null,"<ESSAI1 - Appart>"]
[null,"A4","AAA brispy 16x90g R B H",null,null,null,"<ESSAI2 - Appart>"]
[null,"B1","AAA fares 14*11*20g GB",null,null,null,"<ESSAI1 - Appart>"]
[null,"B2","AAA bbbe 20x330g P",null,null,null,"<ESSAI2 - Appart>"]
[null,"B3","AAAA dggff 14x1 550g C",null,null,null,"<ESSAI1 - Appart>"]
[null,"B4","AAAA fgdff 24*36g FR",null,null,null,"<ESSAI2 - Appart>"]
[null,"C1","AAAA fgsfgs 27*170g ",null,null,null,"<ESSAI1 - Appart>"]

{"sheet":"Feuil3","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(ADDRESS(MATCH(Feuil1!A1,B:B,0),2,,,\"Feuil3\"),\"Feuil3!B1\")","v":"Feuil3!$B$3"},"<< la formule de cette cellule définit l'adresse à afficher elle ne doit pâs être modifiée"]
[null,"A1","pour adaptation à une autre adresse voir:"]
[null,"A2","onglet développeur / VBA / moudule 1 sub TROUVE et caler l'adresse INDIRECT sur la cellule utilisée"]
[null,"A3"]
[null,"A4"]
[null,"B1"]
[null,"B2"]
[null,"B3"]
[null,"B4"]
[null,"C1"]
[null,"C2"]
[null,"C3"]
[null,"C4"]