VLOOKUP returning strange data when not typed in manually

[TimmyBird]

Hi!

I'm having problems with VLOOKUP.
The formula looks as follows:
=VLOOKUP(K22;Scope!$A$2:$B$66;2;0)

Now, when I type the formula in manually it works out just fine but if Icopy/paste or autofill it returns the same data as the one cell i'm using to fill from. This is really stressing me out! I can't type this in manually in 797 cells.

Please help!

 

[Beyond_avarice]

It looks you are using Openoffice "Calc" syntax.

Use commas instead of semicolons.

 

[TimmyBird]

That's what I did at first but Excel wouldn't buy it. Probably down to me using a Swedish version.

Funny thing: If I paste the formula and get the wrong data in return, I can press F2 to enter the formula, then press enter and get the desired result. Very strange indeed!

 

[JoeMo]

That's what I did at first but Excel wouldn't buy it. Probably down to me using a Swedish version.

Funny thing: If I paste the formula and get the wrong data in return, I can press F2 to enter the formula, then press enter and get the desired result. Very strange indeed!

Check to see if you have calculation set to manual. Formulas>Calculation>Calculation Options>Automatic.

 

[Beyond_avarice]

Swedish huh. Try VTSÖK. for 2010 and LETARAD for older.

 

[TimmyBird]

Check to see if you have calculation set to manual. Formulas>Calculation>Calculation Options>Automatic.

That was it! Lovely! Thank you very, very much!