Modified VLOOKUP function to return value and cell formatting

[Cheshire]

Hello,

I'm trying to track down a vlookup/equivalent piece of VBA codeto modify so that when I assign the function and variables in the cell it will not just return the lookup value, but also the cell color.

Any help is greatly appreciated.

Cheers!

[brynbaker]

Use the match function to do the lookup, then index to get the value, and the color or other property.
It will look something like this outline

Please Login or Register  to view this content.