How do I get an exact copy from a lookup reference.(Font style)

W

windpower

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?
 
D

Dave Peterson

Formulas return values--not formats.

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

Héctor Miguel

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?
Click to expand...

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_column_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.
 
Top