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. |
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) |