Trying to call a different value, depending on if cells are empty or not

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.