{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":"Feuil1","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table de recherche :",null,null,"Valeur recherchée :",null,"Résultat fonction RECHERCHEV classique :"]
[null,"Noms de personnes","Objets",null,"Pierre",null,{"$f":"VLOOKUP(E3,B4:C9,2,FALSE)","v":"Ordinateur"}]
[null,"Jean-Paul","TV"]
[null,"Pierre","Ordinateur"]
[null,"Pierre","Console",null,null,null,"Résultats multiples sur une seule ligne :"]
[null,"Pierre","Lave-vaisselle",null,null,null,{"$f":"vlookuplist(E3,B4:C9,2,\"//\")","v":"Ordinateur//Console//Lave-vaisselle"}]
[null,"Jean","Réveil"]
[null,"Jacques","Téléphone"]
[]
[null,null,null,null,null,null,"Résultat multiples sur lignes séparées :"]
[null,null,null,null,null,null,{"$f":"vlookuplistsplitpercells(E3,B4:C9,2)","v":"Ordinateur"}]
[null,null,null,null,null,null,"Console"]
[null,null,null,null,null,null,"Lave-vaisselle"]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"/!\\ Toute modification dans une matrice doit se faire sur l'ensemble de la matrice"]
[null,null,null,null,null,null,"Pour valider une formule matricielle, pressez CTRL + MAJ + ENTREE"]