Error on formula - help!!
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
Hello
Your percentage figures are not rounded so when you change the scores the vlookup can't find a match in your grades table. Try rounding them for example.
=ROUND((J14/$G$8)*1,2)
Hope this helps
Please take a few minutes and check out the forum rules and thread titles.
1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks