Post deleted due to tracking down the error
This is not a solution to the problem; please delete it and re-post as a comment.
Without downloading the file, I would hazard a guess that a lookup table and the function VLOOKUP might be a potential solution.
will do. lol thanks. i actually added to the post, couldnt seem to do it before, thanks again for the help.