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.