srinidhi Active Member Aug 30, 2011 #1 Is it possible to keep the source formatting in the vlookup result? As far as my knowledge goes it is not possible. Is there any workaround for this.I don't want to write macros as the range keeps changing all the time.
Is it possible to keep the source formatting in the vlookup result? As far as my knowledge goes it is not possible. Is there any workaround for this.I don't want to write macros as the range keeps changing all the time.
vijaySharma Member Aug 30, 2011 #2 Certainly not possible using vlookup only... however you can look at the code in the below post to get some help... http://chandoo.org/forums/topic/check-4-duplicate-copy-format-values-of-orginals-row-over-dupicates-row ~VijaySharma
Certainly not possible using vlookup only... however you can look at the code in the below post to get some help... http://chandoo.org/forums/topic/check-4-duplicate-copy-format-values-of-orginals-row-over-dupicates-row ~VijaySharma