{"id":15088,"date":"2021-12-17T16:01:02","date_gmt":"2021-12-17T16:01:02","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=15088"},"modified":"2021-12-17T16:01:19","modified_gmt":"2021-12-17T16:01:19","slug":"solved-vba-formula-to-carry-format-with-vlookup","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vba-formula-to-carry-format-with-vlookup\/16593.html","title":{"rendered":"Solved VBA Formula To Carry Format With VLOOKUP"},"content":{"rendered":"<p>Hi everybody<\/p>\n<p>I have been trying to find my way around getting VBA to carry the format of the result when using VLOOKUP. I am novice in VBA and struggling with no success.<br \/>\nWould you be able to help me out with that?<\/p>\n<p>Is there any other way to combine values(and formats) from two different datasheets without using VBA?<\/p>\n<p>Thanks a lot<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":11},"question-category":[53],"question_tags":[],"class_list":["post-15088","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/15088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=15088"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=15088"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=15088"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=15088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}