Vlookup Pasting Incorrectly

[CTCarlisle]

I have worked in vlookup land for years and this is something new that I cannot figure out! I have applied a standard vlookup formulas to a very large set. I am trying to copy and paste the formula down the page. When paste the formula to the following rows, the result is the value of the copied cell and not the true value of the lookup. My first thought was to see if i should paste special and that did not work either. what am i doing wrong? The below example shows my primary look up table which has my table in numerical order in column A, the lookup value is in column F (6), and column M (Portfolio) should be the correct result. You'll notice that the first row is correct and when i copy and paste to the following row/s, it copies the value not the correct Portfolio. What in the world am i doing wrong!?

 

[Joe4]

Welcome to the Board!

Is your calculation mode set to Automatic or Manual?
What happens when you press F9?

 

[CTCarlisle]

OMG! how simple was that! What did I do? And I am guessing that at some point I pressed it accidentally. I do want to know what function it was. is there another board that i can look at and learn more about it?

 

[Joe4]

It often means that you opened up some file that had the calculation mode set to manual, so that was the default for the following files you open.
Once you set it back to automatic, it should stay that way (at least until you encounter another workbook that has it set to manual).

See here: Why does Excel's calculation mode keep changing? - Excel Off The Grid