Hello everyone, I had read several posts and know that the function of "vlookup" in excel cannot copy the format.
I would like to ask: when I choose the item in column F (under the sheet of "Standard"), the content / format shown in column H can be the same of the sheet in "Data".
Since I am not familiar in VBA, could anyone can suggest the method / solution ?

Sample excel was also attached for your reference.

Much thanks.

Vicky =)


Summary.zip