Try =IF(e3="","",lookup(e3,$ER$6:$er$26,$es$6:$es$26))

Please find the below note on absolute references. Use F4 in formula edit
mode to generate the dollar signs

$A$1 Both column and row references are fixed. Both column and row will be
changed during a copy/fill operation.

$A1 Only column reference is fixed but row will change

A$1 Only row reference is fixed but the column will change.

--
If this post helps click Yes
---------------
Jacob Skaria


"Colm" wrote:

I need to copy the fomula =if(e3="","",lookup(e3,er6:er26,es6:es26))
When I copy the lookup range changes. I tried using $ in front of er6,
er26,es6,and es26. But this lookup cells change. How do i copy the fomula and
keep the lookup destination.