Not sure what you want but try this;
type your name in the address box on the top-left and press enter
this will select the named range
type your formula and then press CTRL-ENTER ... your formula will be copied
to all cells in the range.



" VLOOKUP fORMULA" wrote:

Any one please help me......?

Is there any way to give a formula to a named range.
for example:-

I have given a name Range1 for D10:D20
I need to give a formula <a1+a2
and copy the formula to D10:D20

Tks