Hello - I run a solver every day for a sports program. When I have at least 200 names in the solver it's quite quick. However when there are not 200 players I have to manually delete the #N/A's to run the solver. I have tried to solve (no pun intended) this problem by zeroing out blanks, but I can't figure out the right IF formula.
See attached sheet below (the formulas still represent my master sheet but the gist of what I'm trying to accomplish is there.)
In Column D there is a formula that says if the lookup value = 0 then return 0, if not then return a value. What I'd like to do is ONLY run that lookup if there is a value in the column C greater than 0.
Hopefully the attachment helps - thanks in advance.
Bookmarks