| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUPS
Hi
Im trying to copy a VLOOKUP formula for the table being searched in ... down all the cells in a column and want to auto enter the "$" prefixes to preserve absolute cell refereneces. Example How do I automatically enter =VLOOKUP(C2,Sheet1!C$2:D$5,2,FALSE) instead of what normally comes up - which is =VLOOKUP(C2,Sheet1!C2:D5,2,FALSE) Has anyone any idea idea how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookups | Excel Worksheet Functions | |||
| Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
| Vlookups | Excel Discussion (Misc queries) | |||
| Vlookups | Excel Worksheet Functions | |||
| Vlookups | Excel Discussion (Misc queries) | |||
Threaded Mode
