Vlookup that finds a match and copies the cell formatting as well

**CSUF2009** · 07-10-2013, 07:49 PM

Strangely enough, this is by far the most difficult solution to find. I just want a vlookup to give me the answer along with the cell formatting. I understand a function cannot yield cell formatting - however there is VBA code that will. I just cannot figure out the code for this somwhat simple task.

**alansidman** · 07-10-2013, 07:53 PM

This thread had a similar situation

http://www.excelforum.com/excel-prog...using-vba.html

It is not exactly the same, but you should be able to adapt from the code provided.

Alan

**CSUF2009** · 07-10-2013, 08:01 PM

Not quite what I was looking for buddy. I appreciate the attempt. I have seven vlookups roughly 300 rows long that need to copy over the cell value and the cell format.

**alansidman** · 07-10-2013, 08:07 PM

Perhaps you should post a sample document so that we can provide you with a response suitable to your situation.

**FDibbins** · 07-11-2013, 12:38 AM

You will need a VBA solution for this. Formulas do not copy formatting across. The closest you will come, is if there is some logic/rule to the formatting, you might be able to use Conditional Formatting