{"id":3810,"date":"2019-01-02T16:53:20","date_gmt":"2019-01-02T16:53:20","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3810"},"modified":"2024-03-30T00:27:23","modified_gmt":"2024-03-30T00:27:23","slug":"conditional-formatting-in-vlookup-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/conditional-formatting-in-vlookup-in-excel\/","title":{"rendered":"Conditional Formatting in Vlookup in Excel"},"content":{"rendered":"\n
The vlookup function is used to look up and retrieve information from the selected column in a table. If you used this function, you probably noticed that the information you retrieved doesn\u2019t keep the original number formatting.<\/p>\n\n\n\n
The general formatting cannot be applied by a formula, you have to use VBA code.<\/p>\n\n\n\n
First, let\u2019s try to use VLOOKUP<\/strong> and see what happens with the formatting.<\/p>\n\n\n\n The following worksheet has two sheets.<\/p>\n\n\n\n Sheet1<\/strong> consists of 10 names in which we want to look up salaries from the other sheet.<\/p>\n\n\n\n