Retaining Formats

M

Mike

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 return values only.
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
Click to expand...
 

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 from VLOOKUP 1
Replacing "IF" or "Lookup" formulas with VBA function 6
LOOKUP Function 2
Need formula or macro 2
VBA Copy Range of cells with a condition to another worksheet 3
New Worksheet Values Auto Displayed on Sheet 1 4
Please Help with Two Table Merging 1
URGENT -- search in string for a value in another column, if found, return value from next column 4

Top