Vlookup question

P

Paul Hyett

When pulling values through from a table array, is there any way that
the formatting can be pulled through too, not just the value? (Office
2003)
 
P

Pete_UK

No, a formula can only return a value.

If the format applied to the table was conditionally formatted, then
you could apply the same conditions to the cell with the formula.

Hope this helps.

Pete
 
P

Paul Hyett

No, a formula can only return a value.

If the format applied to the table was conditionally formatted, then
you could apply the same conditions to the cell with the formula.

Hope this helps.
Click to expand...

It's worth looking into at least - thanks.
 
Top