Copying index/ match formula

L

LJoe

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!
 
F

Franz Verga

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
 
Top