| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get a formual to stay constant in vlookup in Excel 2003
This is a common problem. The trick is to use dollar signs when specifying
the table: =VLOOKUP(1.3,$A$1:$C$10,2) rather than =VLOOKUP(1.3,A1:C10,2) -- Gary''s Student "Kappy" wrote: When I do a vlookup and drag the formula down all the rows the formula increments for each row so I wind up only getting partial data to move from one spreadsheet to another. This is in Excel 2003. Do not seem to have the same problem in Excel 2000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
| Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
| Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
