Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get a formual to stay constant in vlookup in Excel 2003
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 |
#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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get a formual to stay constant in vlookup in Excel 2003
Hi, Perhaps you have to set whether the cell references in the formula to be fixed in both row or column both whenever they are extended down using F4 (eg. $A$3, $A3, A$3 or A3) so that when you specify a constant, make sure both its row and column has a dollar sign so that all the references extended will still pickup the same reference. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=546172 |
Reply |
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) |