IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: spimuch on January 23, 2011, 05:11:27 pm

Title: ICT Microsoft Excel problem
Post by: spimuch 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

Title: Re: ICT Microsoft Excel problem
Post by: Vin on February 13, 2011, 04:09:27 pm

Can you attach the file in your post?

Title: Re: ICT Microsoft Excel problem
Post by: 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!

Title: Re: ICT Microsoft Excel problem
Post by: NotAbod 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