Hi
Im using microsoft excel for my a-level project.
my project is for a primary school teachers grading system.
However when i change the possible marks from 100 to anything above that the VLOOKUP formula will not work correctly and 1%, 3% 5% 7% ect will *** up with #N/A this is by changing the possible marks from 100 to 200.
The formula that i'm using is =VLOOKUP(H14,'Grades Table'!E5:F105,2,FALSE)
Is there anyway or anything that I will be able to do so no matter how many marks the tests are out of this error will not appear
Please see attachment and have a look and try for yourself.
Any ways to resolve this issue please comment!
Jack
which post do you want answered? please dont double post. however when you change to say 200 you can get 1/2 marks say6.5% then as these are not in your table and you ask for exact match you get n/a. you can round up/down to correct this
or add the 1/2% values to the table or try sorting the table ascending then change the vlook up to true instead of false. so 11.5% would return the value associatedwith 11%. incidently cells are formated to percentage no decimal places so you cant see the 0.5% .
Last edited by martindwilson; 01-05-2012 at 08:40 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks