Help with keeping Source Formmating

[microhunt]

I am using the Vlookup formula below. I would like to keep the source formatting from the Vlookup worksheet which is called "Vlookup"

Can anyone help me with how I could do this either with formula or VBA.

=IF(ISNA(VLOOKUP($A10,Lookup!$B$2:$C$100,2)),"",VLOOKUP($A10,Lookup!$B$2:$C$100,2))

Thanks

 

[Jeffrey Mahoney]

Hi Microhunt,

Formulas cannot mimic formatting from any other cell. VBA is capable of copying formatting. It's easy to create code to copy broad formatting from one table to another or even a cell at a time, but I would guess the code to format cells based on source cell in a formula would be daunting.

You might want to consider using IFERROR in that formula above.
=IFERROR(VLOOKUP($A10,Lookup!$B$2:$C$100,2),"")

Jeff