Retaining Formats from VLOOKUP

S

Squid

I have a Vlookup formula in worksheet1 that looks up
values from worksheet2. These values in worksheet2 can
either be percentages or currency amounts.

Is it possible to have vlookup (or via code) to have
return value from the lookup to retain the format from
worksheet2?

Thanks
Mike
 
D

Dave Peterson

Formulas can return values--not formatting.

Any chance you can use Format|conditional formatting to duplicate the
formatting?

(Use the same rules in both spots.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retaining Formats 1
Populating multiple cells from a single pull down 2
VLOOKUP query 6
Data consolidation from Multiple Sheets 1
LOOKUP Function 2
VLookup 1
Which formula would work for this series? ..Help needed 4
Excel Worksheet Not Being Saved 1

Top