{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","Результат"],"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":"Данные","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Менеджер","Клиент",null,null,null,"Маша","Ваня","Петя","Федя",null,"Маша","Ваня","Петя","Федя"]
["Маша","Маэстро, кафе",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F1,)),$B$2:$B$29),\"\")","v":"Фаворит, ООО, рекламно-производственная компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G1,)),$B$2:$B$29),\"\")","v":"Ратибор, ООО, охранное предприятие"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H1,)),$B$2:$B$29),\"\")","v":"Фалькон, лазертаг-клуб"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I1,)),$B$2:$B$29),\"\")","v":"АвтоСпецТехника, ООО"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K1))),\"\")","v":"Маэстро, кафе"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L1))),\"\")","v":"Авангард-спецодежда Оренбург, ООО, производственно-торговая компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M1))),\"\")","v":"Hotel Grand, гостиничный комплекс"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N1))),\"\")","v":"Bosal+, магазин автотоваров"}]
["Маша","Территория Красок, торговая фирма",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F2,)),$B$2:$B$29),\"\")","v":"Урал-Резерв, торговая компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G2,)),$B$2:$B$29),\"\")","v":"Пункт проката горных лыж и сноубордов, ИП Гавриков М.А."},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H2,)),$B$2:$B$29),\"\")","v":"Hotel Grand, гостиничный комплекс"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I2,)),$B$2:$B$29),\"\")","v":"Автомобильная служба, ИП Чердинцева О.И."},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K2))),\"\")","v":"Территория Красок, торговая фирма"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L2))),\"\")","v":"Автотент центр, производственно-торговая фирма"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M2))),\"\")","v":"Фалькон, лазертаг-клуб"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N2))),\"\")","v":"Krovelson, производственно-торговая компания"}]
["Маша","Урал-Резерв, торговая компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F3,)),$B$2:$B$29),\"\")","v":"Территория Красок, торговая фирма"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G3,)),$B$2:$B$29),\"\")","v":"Оптик-Сити, салон оптики"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H3,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I3,)),$B$2:$B$29),\"\")","v":"авто Rally, торгово-сервисная фирма"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K3))),\"\")","v":"Урал-Резерв, торговая компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L3))),\"\")","v":"Акамуто, студия доставки японской кухни"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M3))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N3))),\"\")","v":"Orengun, магазин"}]
["Маша","Фаворит, ООО, рекламно-производственная компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F4,)),$B$2:$B$29),\"\")","v":"Маэстро, кафе"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G4,)),$B$2:$B$29),\"\")","v":"Мир, производственная компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H4,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I4,)),$B$2:$B$29),\"\")","v":"АвангардСервис, "},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K4))),\"\")","v":"Фаворит, ООО, рекламно-производственная компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L4))),\"\")","v":"Бегемот, сеть кафе"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M4))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N4))),\"\")","v":"АВАЛОН, служба эвакуации автомобилей"}]
["Ваня","Авангард-спецодежда Оренбург, ООО, производственно-торговая компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F5,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G5,)),$B$2:$B$29),\"\")","v":"Медикал Он Груп-Оренбург, ООО, международный медицинский центр"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H5,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I5,)),$B$2:$B$29),\"\")","v":"АВАЛОН, служба эвакуации автомобилей"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K5))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L5))),\"\")","v":"ВЕДИ, ООО, стоматологическая клиника"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M5))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N5))),\"\")","v":"АвангардСервис, "}]
["Ваня","Автотент центр, производственно-торговая фирма",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F6,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G6,)),$B$2:$B$29),\"\")","v":"Крепмаркет, торговая компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H6,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I6,)),$B$2:$B$29),\"\")","v":"Orengun, магазин"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K6))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L6))),\"\")","v":"Делакруа, торгово-монтажная компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M6))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N6))),\"\")","v":"авто Rally, торгово-сервисная фирма"}]
["Ваня","Акамуто, студия доставки японской кухни",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F7,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G7,)),$B$2:$B$29),\"\")","v":"Карамель, лаунж-кафе"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H7,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I7,)),$B$2:$B$29),\"\")","v":"Krovelson, производственно-торговая компания"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K7))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L7))),\"\")","v":"Дракоша, сеть магазинов игрушек"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M7))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N7))),\"\")","v":"Автомобильная служба, ИП Чердинцева О.И."}]
["Ваня","Бегемот, сеть кафе",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F8,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G8,)),$B$2:$B$29),\"\")","v":"Дракоша, сеть магазинов игрушек"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H8,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I8,)),$B$2:$B$29),\"\")","v":"Bosal+, магазин автотоваров"},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K8))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L8))),\"\")","v":"Карамель, лаунж-кафе"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M8))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N8))),\"\")","v":"АвтоСпецТехника, ООО"}]
["Ваня","ВЕДИ, ООО, стоматологическая клиника",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F9,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G9,)),$B$2:$B$29),\"\")","v":"Делакруа, торгово-монтажная компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H9,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I9,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K9))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L9))),\"\")","v":"Крепмаркет, торговая компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M9))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N9))),\"\")","v":""}]
["Ваня","Делакруа, торгово-монтажная компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F10,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G10,)),$B$2:$B$29),\"\")","v":"ВЕДИ, ООО, стоматологическая клиника"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H10,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I10,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K10))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L10))),\"\")","v":"Медикал Он Груп-Оренбург, ООО, международный медицинский центр"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M10))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N10))),\"\")","v":""}]
["Ваня","Дракоша, сеть магазинов игрушек",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F11,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G11,)),$B$2:$B$29),\"\")","v":"Бегемот, сеть кафе"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H11,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I11,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K11))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L11))),\"\")","v":"Мир, производственная компания"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M11))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N11))),\"\")","v":""}]
["Ваня","Карамель, лаунж-кафе",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F12,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G12,)),$B$2:$B$29),\"\")","v":"Акамуто, студия доставки японской кухни"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H12,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I12,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K12))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L12))),\"\")","v":"Оптик-Сити, салон оптики"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M12))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N12))),\"\")","v":""}]
["Ваня","Крепмаркет, торговая компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F13,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G13,)),$B$2:$B$29),\"\")","v":"Автотент центр, производственно-торговая фирма"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H13,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I13,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K13))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L13))),\"\")","v":"Пункт проката горных лыж и сноубордов, ИП Гавриков М.А."},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M13))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N13))),\"\")","v":""}]
["Ваня","Медикал Он Груп-Оренбург, ООО, международный медицинский центр",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F14,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G14,)),$B$2:$B$29),\"\")","v":"Авангард-спецодежда Оренбург, ООО, производственно-торговая компания"},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H14,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I14,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K14))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L14))),\"\")","v":"Ратибор, ООО, охранное предприятие"},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M14))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N14))),\"\")","v":""}]
["Ваня","Мир, производственная компания",null,null,null,{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=F$1)/ISNA(MATCH($B$2:$B$29,F$1:F15,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=G$1)/ISNA(MATCH($B$2:$B$29,G$1:G15,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=H$1)/ISNA(MATCH($B$2:$B$29,H$1:H15,)),$B$2:$B$29),\"\")","v":""},{"$f":"IFERROR(LOOKUP(,-1/($A$2:$A$29=I$1)/ISNA(MATCH($B$2:$B$29,I$1:I15,)),$B$2:$B$29),\"\")","v":""},null,{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=K$1,ROW($1:$28)),ROW(K15))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=L$1,ROW($1:$28)),ROW(L15))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=M$1,ROW($1:$28)),ROW(M15))),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$29,SMALL(IF($A$2:$A$29=N$1,ROW($1:$28)),ROW(N15))),\"\")","v":""}]
["Ваня","Оптик-Сити, салон оптики"]
["Ваня","Пункт проката горных лыж и сноубордов, ИП Гавриков М.А."]
["Ваня","Ратибор, ООО, охранное предприятие"]
["Петя","Hotel Grand, гостиничный комплекс"]
["Петя","Фалькон, лазертаг-клуб"]
["Федя","Bosal+, магазин автотоваров"]
["Федя","Krovelson, производственно-торговая компания"]
["Федя","Orengun, магазин"]
["Федя","АВАЛОН, служба эвакуации автомобилей"]
["Федя","АвангардСервис, "]
["Федя","авто Rally, торгово-сервисная фирма"]
["Федя","Автомобильная служба, ИП Чердинцева О.И."]
["Федя","АвтоСпецТехника, ООО"]

{"sheet":"Результат","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Маша","Ваня","Петя","Федя"]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]
[{"$f":"VLOOKUP($A$1,Данные!$A$1:$B$29,2,FALSE)","v":"Маэстро, кафе"}]