Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Copy Formula
I have Excel version 2003 and spreadsheet that I am using the vlookup function. When I type in the vlookup function the first time it functions properly. I dragged the vlookup function (first time) to the other cells it outputs the same value for all cells. The same value the first time the vlookup function was enter. Please help resolve this issue. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Copy Formula
It sounds as if you have manual calculation for your workbook. Go to menu
Tools|Options, Calculation tab, and check Automatic calculation. -- ** John C ** "Joe K." wrote: I have Excel version 2003 and spreadsheet that I am using the vlookup function. When I type in the vlookup function the first time it functions properly. I dragged the vlookup function (first time) to the other cells it outputs the same value for all cells. The same value the first time the vlookup function was enter. Please help resolve this issue. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Copy Formula
Joe,
It sounds like your using absolute addressing like this =VLOOKUP($B$10,$A$1:$C$5,3,FALSE) If you want the formula tom increment when you drag you need this =VLOOKUP(B10,$A$1:$C$5,3,FALSE) Note that b10 will now increment when dragged but the lookup range wont. Mike "Joe K." wrote: I have Excel version 2003 and spreadsheet that I am using the vlookup function. When I type in the vlookup function the first time it functions properly. I dragged the vlookup function (first time) to the other cells it outputs the same value for all cells. The same value the first time the vlookup function was enter. Please help resolve this issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with copy/paste VLOOKUP formula | Excel Discussion (Misc queries) | |||
Copy VLookup formula from one spreadsheet to another | Excel Discussion (Misc queries) | |||
How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
How to automatically copy VLOOKUP FORMULA IN A COLUMN | Excel Discussion (Misc queries) | |||
Copy VLOOKUP Formula | Excel Discussion (Misc queries) |