Qualification > Miscellaneous

ICT Microsoft Excel problem

(1/1)

spimuch:
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

Vin:
Can you attach the file in your post?

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

NotAbod:

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

--- End quote ---
u can just press F4 and dollar signs will be placed

Navigation

[0] Message Index