When using 'lookup' I want to get a exact copy of what is in the result
field. This may be specific font type, size, colour etc. can anybody help?

Formulas return values--not formats.

You'll have to find a different way (maybe copy|paste special|formats???)

windpower wrote:

When using 'lookup' I want to get a exact copy of what is in the result
field. This may be specific font type, size, colour etc. can anybody help?

--

Dave Peterson

hi, !

When using 'lookup' I want to get a exact copy of what is in the result field.
This may be specific font type, size, colour etc. can anybody help?

a workaround...

1) use the camera tool over any cell within your lookup-table and paste it
(i.e.) "above" the cell where you want the "result"
(you would have to select this cell with arrow-keys, not by mouse)

2) define a name referring your lookup-table (i.e.) using:
desref(<first_cell,match(<look_data,<first_colum n_lookup-table,0*now()),n)
exact match-type for the row displacement and for column displacement (n)
the same column_number as your lookup-formula

3) select the pasted picture and type =defined_name (IN THE FORMULA BAR)

hth,
hector.