HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME
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. |
HOW TO I GET LOOKUP TO USE THE SAME RANGE EVERYTIME
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. |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com