I am using vlookup function in Excel 2013, it works awesome.
My problem is that the function does not bring the formatting of the text / value, it only bring the raw value.
I understand that there is a way to use "VBA" to do this.
Can anyone help me with a script for VBA or other solution?
Here is an example of the excel I am working with:
SMO Due to the presence of a soffit to the underside of the stairs and narrow carpet to the top surface the margins only could be inspected.
STSO Due to the presence of a soffit to the underside of the stairs our inspection was confined to the top surface only.
SSL The stairs are of solid construction.
When I type the Code and press tab/enter it auto-completes with the description.
The formula I use is simple: =VLOOKUP(A1,Data,2,FALSE)