vlookup passes formatting

**noahwallach** · 09-04-2009, 05:17 PM

HI there,

I am using the command =IF(E23="","",VLOOKUP(E23,Lookups!$A$2:$B$8,2,FALSE))
to pass values
but i also want the associated formatting to appear in the field making the vlookup call. How do I do that?

Cheers,

Noah

**shg** · 09-04-2009, 05:39 PM

Won't happen. You'd need VBA.

**noahwallach** · 09-04-2009, 07:35 PM

what is VBA?

**shg** · 09-04-2009, 07:37 PM

Visual Basic for Applications, Microsoft's automation language for the Office suite.

**noahwallach** · 09-05-2009, 04:24 PM

is Visual Basic for Applications a separate purchase? or something I can download free?

**shg** · 09-05-2009, 06:28 PM

It comes with Office, but you have to elect to install it when you install.

If you do Alt+F11 from Excel, and a window titled Microsoft Visual Basic opens, it's installed.