Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003
I am trying to make multiple copys of a function i wrote to go down an entire
column L | M | N -----------------------------------------------------| | 2 | KY | =lookup(L2,v2:w63) | | 3 | NJ | =lookuo(L3,v2:w63) | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | This is what i want the drag and copy to do....| -----------------------------------------------------| Below is what i get L | M | N -----------------------------------------------------| | 2 | KY | =lookup(L2,v2:w63) | | 3 | NJ | =lookuo(L3,v3:w64) | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | This is what i get with the drag and copy | -----------------------------------------------------| My question is this is it possible to do what i want so that i dont have to retype the formula in column M for each new row. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003
Change:
2 | KY | =lookup(L2,v2:w63) | | To: 2 | KY | =lookup(L2,$v$2:$w$63) | | That should work. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |