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!
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!