Lookup formats

[freekrill]

Hi,

This may be a long shot, but...

As well as the value being looked up from a look up table, is i
possible for the format of the "looked up" cell to be carried across?

eg. a1 contains the formula =vlookup(b1,c1:d100,2)

The values in column d in the lookup table are colour-coded. Can th
lookup function be made to include this colour coding?


Thanks
fre

 

[elstuart]

An alternative may be to use conditional formatting, based on the answe
given.

Not sure if it helps.

Li

 

[Frank Kabel]

Hi
a formula can't do this. If you need a lookup based on value AND color
you'll need VBA (cycling through the entire range and checking the
value AND the colorindex.

Probably better to use a second column with another information
(instead of using a color)

 

[freekrill]

Thanks for your advices. I thought it was unlikely that it could b
achieved simply.

fre