Match fields with formatting and justification

The problem is similar to

https://www.excelforum.com/excel-pro...ml#post4813237

I have database sheet called SOR
Output sheet is called EST

When code is entered in EST sheet, the Description and Unit field in EST sheet shall be populated based on the SOR sheet.
If there is no match, the Description and Unit field should be blank.

I want to preserve the formatting of the SOR sheet in EST sheet. The Description field in EST sheet need to be justified and aligned to top also for all items.

I tinkered with the following code but unsuccessful

Please Login or Register  to view this content.

Working file is attached