{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PORTADA","Hoja2","Hoja1"],"not_rendered":{"charts":0,"images":1,"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":"PORTADA","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Lista de reproducción: "]
[null,null,"https://www.youtube.com/playlist?list=PLrhlyizWZzOERwRMxIIy-BTP-CyXh_K5N&playnext=1"]
[null,"Blog:  "]
[null,null,"https://elsamatilde.blogspot.com/    "]
[null,"Sitio web: "]
[null,null,"http://aplicaexcel.com/index.htm"]

{"sheet":"Hoja2","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["FACTURACIÓN"]
["Cod Cliente","Doc Numero","DocVto","DocFecha","DocSaldo","Vendedor","Cliente Nombre","Suc","TIPO DOCU","Plazo","IMPORTE","DeudaVda"]
[1,1234,null,"2020-01-10",null,"A","AAA",1,null,30,12590]
[2,2345,null,"2020-01-11",null,"B","BBB",1,null,7,15670]
[3,3456,null,"2020-01-12",null,"C","CCC",1,null,15,18750]

{"sheet":"Hoja1","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,1,10,2],[5,4,5,5],[7,4,7,5],[3,4,3,5],[7,1,7,3],[5,1,5,3],[3,1,3,3]]}
[]
[null,"MÉTODOS DE BÚSQUEDA CON VBA:"]
[]
[3,"[C15].FormulaR1C1 = \"=IFERROR(VLOOKUP(RC[-1],Hoja2!C2:C12,6,FALSE),\"\"X\"\")\"",null,null,"Coloca en celda la función BUSCARV. \nNo se controla error."]
[]
[2,"    [C14]= Application.WorksheetFunction.VLookup(dato, Sheets(\"Hoja2\").Range(\"B:H\"), 6, False)",null,null,"Devuelve el resultado de la función BUSCARV. Controlar error dato no encontrado."]
[]
[1,"    Set busco = ho2.Range(\"B:H\").Find(dato, LookIn:=xlValues, Lookat:=xlWhole)",null,null,"Evaluar si busco quedó vacío o no"]
[]
[]
[null,"BÚSQUEDA:"]
[null,"DATO (Doc. Nro.)","RESULTADO  (Cliente)"]
[null,1234]
[null,2345]
[null,3456,{"$f":"VLOOKUP(B15,Hoja2!$B:$L,6,FALSE)","v":"CCC"}]
[null,4567]
[null,1234]
[null,2345]
[null,3456]
[null,7777,{"$f":"IFERROR(VLOOKUP(B20,Hoja2!$B:$L,6,FALSE),\"X\")","v":"X"}]