copy and paste

A

andrew

Hello,
when i'm going to copy a function:
=CERCA.VERT(A15;Dettagli!A6:G65536;6) ------- italian version
excel update the formula changing A15 to A16 and A6:G65536 to A7:G65537
but I nedd only it update A15 to A16.
can you help me please?
 
D

damorrison

Hello,
when i'm going to copy a function:
=CERCA.VERT(A15;Dettagli!A6:G65536;6) ------- italian version
excel update the formula changing A15 to A16 and A6:G65536 to A7:G65537
but I nedd only it update A15 to A16.
can you help me please?
Click to expand...

Check out Absolute vales, something like
=CERCA.VERT(A15;Dettagli!$A$6:$G$65536;6)
 

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

copy & paste 1
Calculating sum product between columns. 3
Copy Formula Down Without Changing Entire Formula 3
How do you repeat a function in a formula 4
How to use indirect function? 6
How do I sum a formula and paste it in 7 cell increments? 4
formula or code help 3
How to sort AlphaNumeric Data sequentially with spaces 4

Top