Copy Source Formatting Of The Lookup Cell

Question

Good day,
I used the sugesstions to copy the formatting from the source using the suggestions as described by the link below.
https://www.extendoffice.com/documents/excel/5053-excel-vlookup-copy-formatting.html
When I use the suggetion as desribed the excel hangs and does not pull through the result.
The reason I need this function is the source is either a number, Currency or percentage.
Your assitance in this regard will greatly be appreciated.

Doug