On Feb 2, 7:02*pm, andrew wrote:
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?

--
BBB

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