Copying index/ match formula
 

Is there a way to copy an index/ match formula down the page? I am going to
have over 5000 cells on my owrksheet and I am hoping I don't have to enter
each formula individually.
Thank You!

Copying index/ match formula
 

Nel post
*LJoe* ha scritto:

Is there a way to copy an index/ match formula down the page? I am
going to have over 5000 cells on my owrksheet and I am hoping I don't
have to enter each formula individually.
Thank You!

Yes, you can copy the formula but you have to set properly the references
inside. So the range to search within must be in absolute references, while
the lookup cell should be in relative or mixed references.

Should have problem, post your formula so we can give more help.

You can also search the on line help for "references" (without quotes).


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Copying index/ match formula
 

Thank you so much for the help! It is working great!


"Franz Verga" wrote:

Nel post
*LJoe* ha scritto:

Is there a way to copy an index/ match formula down the page? I am
going to have over 5000 cells on my owrksheet and I am hoping I don't
have to enter each formula individually.
Thank You!

Yes, you can copy the formula but you have to set properly the references
inside. So the range to search within must be in absolute references, while
the lookup cell should be in relative or mixed references.

Should have problem, post your formula so we can give more help.

You can also search the on line help for "references" (without quotes).


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy