Vlookup question

[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)

 

[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

 

[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.

It's worth looking into at least - thanks.