{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист с расценками"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Лист1","index":0,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["№ п/п","-","№ расценки","Наименование","Ед.изм.","Кол-во","Сумма2",null,"Сумма2\nКак хотелось бы чтобы макрос выводил в столбце \"G\""]
["п.1",1,"Расценка1","Наименование1","кг",36,{"$f":"ROUND(F2*VLOOKUP(C2,расценки,3,FALSE),2)","v":175.2},null,{"$f":"ROUND(F2*4.8666454904779,2)","v":175.2}]
["п.2",2,"Расценка2","Наименование2","м",65.42,{"$f":"ROUND(F3*VLOOKUP(C3,расценки,3,FALSE),2)","v":9148.44},null,{"$f":"ROUND(F3*139.841568379447,2)","v":9148.44}]
[]
[null,null,null,null,null,null,null,null,"Хотелось бы, чтобы вместо части формулы \"ВПР(C2;расценки;3;ЛОЖЬ)\" выводилось ЗНАЧЕНИЕ из таблицы \"расценки\", то есть \"4,8666454904779\" для п.1 и \"139,841568379447\" для п.2"]

{"sheet":"Лист с расценками","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[1,"Хар-ка1","Хар-ка2","Хар-ка3","Хар-ка4"]
["Расценка1",32.444303269852703,4.8666454904779002,0,0]
["Расценка2",932.27712252964398,139.84156837944701,0,41.2206545454546]