VLOOKUP not copying

T

taup41

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am having trouble copying formula down a column, for some reason the the result is being copied not the formula. Is there a special setting I have missed. I have not had this issue before.

Thanks
 
C

CyberTaz

In order for anyone to have any idea what might be wrong it would be helpful
if you'd describe how your sheet is arranged (including the lookup table),
indicate exactly how your formula is written, what specific method you're
using to copy the formula, as well as what "result" is being copied. Also,
what shows in the Formula Bar when you select a cell you've copied to?

There is no "setting" or preference to copy results instead of formulas
unless you explicitly use Paste Special. The explanation most likely lies in
the information requested above, but nobody here can "see" any more of your
work than what you show here :)

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

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

VLOOKUP not copying 3
error with exel 1
Formula Bar Problem 1
if & vlookup 5
function for array 1
copying date issues 1
Auto hide in excel 2008 8
cannot enter a long series of numbers without excel changing them. 3

Top