Find Target Sum in EXCEL

SPEED is of the outmost importance. Solver is unable to handle volume in a timely manner. From a list of upto 2000 (although the more the better) rows of numbers I want a program for excel that will tell me which numbers equal my target sum by placing a qualifier in the adjacent column. If more than one solution is possible it should put the qualifier +1 in the adjacent column. It should allow the range of acceptable variance from the target sum to be entered. ie if no results are found the option to display the closest solution is available. Display option should include feature that looks similair to the f2 function in excel. It should not take more than a few minutes. SPEED is of the outmost importance.