Is there any way to use a Vlookup that also takes the format from the data table?

I.e. my data table contains some absolute numerical values and some percentages. I would like the Vlookup to find the correct data value and then format it to match the cell, from which, the data was obtained.

Any ideas? Thanks,

R.