Thread: Vlookup with formatting

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.

Hi Arthur,

Thanks for the response. I thought that might be the case. I wanted to avoid macros if possible, but I might have to go down this route.

Thanks again,

R.