| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TROUBLE COPYING AND PASTING FORMULAS
I'm trying to copy the following formual into a column of cells:
=VLOOKUP(G10,Data!B1:C11,2,FALSE) But every time I copy/paste, Excel decides to change my Data!B1:C11 table array screwing up my formula. There has got to be a better way. Also, this will not allow me to cut and paste multiple versions of my excel file. The "look up" value does change appropriately. Please help. I have tried everything. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying and pasting multiple formulas, it it possible? | Excel Discussion (Misc queries) | |||
| Copying & pasting formulas | Excel Worksheet Functions | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
| Trouble copying and pasting a formula | Excel Worksheet Functions | |||
Threaded Mode
