« previous next »
Pages: [1]   Go Down

Author Topic: ICT Microsoft Excel problem  (Read 2173 times)

Offline spimuch

  • Newbie
  • *
  • Posts: 5
  • Reputation: 24
ICT Microsoft Excel problem
« on: January 23, 2011, 05:11:27 pm »
hi ,

i was practicing microsoft excel and i got stuck in a problem ...when i use the Vlookup function it gives only the first two results correct and the rest are all either N/A or VALUE ! ...

when i check the formula the values are different then the ones i entered...

for example if i chose my table to be from A2 till B7 ,the first few will be set within that table and the rest will be waay different like A17 or B27
Logged

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: ICT Microsoft Excel problem
« Reply #1 on: February 13, 2011, 04:09:27 pm »
Can you attach the file in your post?
Logged

Offline girl95

  • Newbie
  • *
  • Posts: 3
  • Reputation: 24
Re: ICT Microsoft Excel problem
« Reply #2 on: March 21, 2011, 10:47:53 am »
well make sure that there's absolute and cell referencing
so if the range is A1:A15 put the dollar sign so that it's like this $A$1:$A$15
this way the range wont change as u go down the column

hope this helps!
Logged

Offline NotAbod

  • Wikipedia Contributor
  • Global Moderator
  • SF Farseer
  • *****
  • Posts: 3929
  • Reputation: 65535
  • Gender: Male
Re: ICT Microsoft Excel problem
« Reply #3 on: March 25, 2011, 05:43:06 pm »
Quote from: girl95 on March 21, 2011, 10:47:53 am
well make sure that there's absolute and cell referencing
so if the range is A1:A15 put the dollar sign so that it's like this $A$1:$A$15
this way the range wont change as u go down the column

hope this helps!
u can just press F4 and dollar signs will be placed
Logged
Pages: [1]   Go Up
« previous next »