{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["выборка","вопр"],"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":"выборка","index":0,"n_rows":166,"n_cols":9,"rows_kept":166,"cut":false,"hidden":false,"merged":[]}
["№","УР1","УР2","УР3","УР4"]
[645,"ааа645",null,null,"йй645"]
[236,"ааа236",null,null,"йй236"]
[341,"ааа341",null,null,"йй341"]
[55,"ааа55",null,null,"йй55"]
[293,"ааа293",null,null,"йй293"]
[561,"ааа561",null,null,"йй561"]
[118,"ааа118",null,null,"йй118"]
[131,"ааа131",null,null,"йй131"]
[148,"ааа148",null,null,"йй148"]
[564,"ааа564",null,null,"йй564"]
[591,"ааа591",null,null,"йй591"]
[79,"ааа79",null,null,"йй79"]
[582,"ааа582",null,null,"йй582"]
[326,"ааа326",null,null,"йй326"]
[347,"ааа347",null,null,"йй347"]
[113,"ааа113",null,null,"йй113"]
[163,"ааа163",null,null,"йй163"]
[35,"ааа35",null,null,"йй35",null,null,"бб15","цц15"]
[98,"ааа98",null,null,"йй98"]
[284,"ааа284",null,null,"йй284"]
[612,"ааа612",null,null,"йй612"]
[88,"ааа88",null,null,"йй88"]
[143,"ааа143",null,null,"йй143"]
[558,"ааа558",null,null,"йй558"]
[153,"ааа153",null,null,"йй153"]
[215,"ааа215",null,null,"йй215"]
[227,"ааа227",null,null,"йй227"]
[103,"ааа103",null,null,"йй103"]
[597,"ааа597",null,null,"йй597"]
[290,"ааа290",null,null,"йй290"]
[95,"ааа95",null,null,"йй95"]
[329,"ааа329",null,null,"йй329"]
[588,"ааа588",null,null,"йй588"]
[639,"ааа639",null,null,"йй639"]
[155,"ааа155",null,null,"йй155"]
[606,"ааа606",null,null,"йй606"]
[633,"ааа633",null,null,"йй633"]
[87,"ааа87",null,null,"йй87"]
[167,"ааа167",null,null,"йй167"]
[228,"ааа228",null,null,"йй228"]
[107,"ааа107",null,null,"йй107"]
[123,"ааа123",null,null,"йй123"]
[178,"ааа178",null,null,"йй178"]
[195,"ааа195",null,null,"йй195"]
[183,"ааа183",null,null,"йй183"]
[335,"ааа335",null,null,"йй335"]
[254,"ааа254",null,null,"йй254"]
[299,"ааа299",null,null,"йй299"]
[242,"ааа242",null,null,"йй242"]
[208,"ааа208",null,null,"йй208"]
[624,"ааа624",null,null,"йй624"]
[576,"ааа576",null,null,"йй576"]
[231,"ааа231",null,null,"йй231"]
[213,"ааа213",null,null,"йй213"]
[570,"ааа570",null,null,"йй570"]
[618,"ааа618",null,null,"йй618"]
[198,"ааа198",null,null,"йй198"]
[296,"ааа296",null,null,"йй296"]
[585,"ааа585",null,null,"йй585"]
[651,"ааа651",null,null,"йй651"]
[567,"ааа567",null,null,"йй567"]
[51,"ааа51",null,null,"йй51"]
[275,"ааа275",null,null,"йй275"]
[269,"ааа269",null,null,"йй269"]
[83,"ааа83",null,null,"йй83"]
[238,"ааа238",null,null,"йй238"]
[278,"ааа278",null,null,"йй278"]
[223,"ааа223",null,null,"йй223"]
[251,"ааа251",null,null,"йй251"]
[317,"ааа317",null,null,"йй317"]
[338,"ааа338",null,null,"йй338"]
[175,"ааа175",null,null,"йй175"]
[302,"ааа302",null,null,"йй302"]
[320,"ааа320",null,null,"йй320"]
[119,"ааа119",null,null,"йй119"]
[39,"ааа39",null,null,"йй39",null,null,"бб19","цц19"]
[239,"ааа239",null,null,"йй239"]
[83,"ааа83",null,null,"йй83"]
[115,"ааа115",null,null,"йй115"]
[621,"ааа621",null,null,"йй621"]
[93,"ааа93",null,null,"йй93"]
[179,"ааа179",null,null,"йй179"]
[266,"ааа266",null,null,"йй266"]
[642,"ааа642",null,null,"йй642"]
[127,"ааа127",null,null,"йй127"]
[138,"ааа138",null,null,"йй138"]
[272,"ааа272",null,null,"йй272"]
[223,"ааа223",null,null,"йй223"]
[233,"ааа233",null,null,"йй233"]
[233,"ааа233",null,null,"йй233"]
[260,"ааа260",null,null,"йй260"]
[546,"ааа546",null,null,"йй546"]
[188,"ааа188",null,null,"йй188"]
[600,"ааа600",null,null,"йй600"]
[199,"ааа199",null,null,"йй199"]
[91,"ааа91",null,null,"йй91"]
[31,"ааа31",null,null,"йй31"]
[68,"ааа68",null,null,"йй68",null,null,17,"ааа17"]
[230,"ааа230",null,null,"йй230"]
[75,"ааа75",null,null,"йй75"]
[245,"ааа245",null,null,"йй245"]
[594,"ааа594",null,null,"йй594"]
[207,"ааа207",null,null,"йй207"]
[23,"ааа23",null,null,"йй23"]
[103,"ааа103",null,null,"йй103"]
[159,"ааа159",null,null,"йй159"]
[549,"ааа549",null,null,"йй549"]
[71,"ааа71",null,null,"йй71",null,null,20,"ааа20"]
[27,"ааа27",null,null,"йй27"]
[67,"ааа67",null,null,"йй67",null,null,16,"ааа16"]
[128,"ааа128",null,null,"йй128"]
[123,"ааа123",null,null,"йй123"]
[248,"ааа248",null,null,"йй248"]
[287,"ааа287",null,null,"йй287"]
[47,"ааа47",null,null,"йй47"]
[135,"ааа135",null,null,"йй135"]
[323,"ааа323",null,null,"йй323"]
[73,"ааа73",null,null,"йй73",null,null,22,"ааа22"]
[314,"ааа314",null,null,"йй314"]
[151,"ааа151",null,null,"йй151"]
[257,"ааа257",null,null,"йй257"]
[139,"ааа139",null,null,"йй139"]
[636,"ааа636",null,null,"йй636"]
[111,"ааа111",null,null,"йй111"]
[191,"ааа191",null,null,"йй191"]
[311,"ааа311",null,null,"йй311"]
[630,"ааа630",null,null,"йй630"]
[143,"ааа143",null,null,"йй143"]
[203,"ааа203",null,null,"йй203"]
[332,"ааа332",null,null,"йй332"]
[183,"ааа183",null,null,"йй183"]
[308,"ааа308",null,null,"йй308"]
[158,"ааа158",null,null,"йй158"]
[573,"ааа573",null,null,"йй573"]
[615,"ааа615",null,null,"йй615"]
[43,"ааа43",null,null,"йй43",null,null,"бб23","цц23"]
[344,"ааа344",null,null,"йй344"]
[603,"ааа603",null,null,"йй603"]
[263,"ааа263",null,null,"йй263"]
[171,"ааа171",null,null,"йй171"]
[163,"ааа163",null,null,"йй163"]
[211,"ааа211",null,null,"йй211"]
[235,"ааа235",null,null,"йй235"]
[579,"ааа579",null,null,"йй579"]
[99,"ааа99",null,null,"йй99"]
[193,"ааа193",null,null,"йй193"]
[609,"ааа609",null,null,"йй609"]
[133,"ааа133",null,null,"йй133"]
[203,"ааа203",null,null,"йй203"]
[59,"ааа59",null,null,"йй59"]
[648,"ааа648",null,null,"йй648"]
[173,"ааа173",null,null,"йй173"]
[187,"ааа187",null,null,"йй187"]
[78,"ааа78",null,null,"йй78"]
[108,"ааа108",null,null,"йй108"]
[281,"ааа281",null,null,"йй281"]
[218,"ааа218",null,null,"йй218"]
[305,"ааа305",null,null,"йй305"]
[168,"ааа168",null,null,"йй168"]
[63,"ааа63",null,null,"йй63",null,null,12,"ааа12"]
[552,"ааа552",null,null,"йй552"]
[555,"ааа555",null,null,"йй555"]
[147,"ааа147",null,null,"йй147"]
[219,"ааа219",null,null,"йй219"]
[627,"ааа627",null,null,"йй627"]

{"sheet":"вопр","index":1,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["столкнулся с такой проблемой, что функция ВПР очень медленно работает."]
["у меня есть очень большая таблица - \"Классификатор\" (примерно 500 тыс. строк), из нее я через ВПР подтягиваю 4 столбца в другую таблицу (30-50 тыс строк). это занимает очень много времени."]
[]
["возможно ли через VBA сделать макрос заменяющий ВПР, но работающий быстрее."]
["необходимо чтобы после запуска такого макроса было следующиее:"]
["1. выскакивало окно с просьбой указать путь к Классификатору."]
["2. далее спрашивало номера столбцов которые необходимо подтянуть."]