Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup range help | Excel Discussion (Misc queries) | |||
help with lookup and range | Excel Worksheet Functions | |||
Macros available everytime | Excel Discussion (Misc queries) | |||
Lookup in a range. | Excel Discussion (Misc queries) | |||
Range Lookup | Excel Discussion (Misc queries) |