Either I am a bit dense or the dynamic named ranges will not work. I understand using the dynamic named ranges requires user input. I do not want user to do anything except import a csv file into sheet one containing data that will automatically get updated in sheet two if the data is between 700 and 800 for example. Sheet one would have numbers ranging from 100 to 1000. I only want the 700 thru 800 to appear in sheet two. Then those in sheet two would be used to lookup the values associated with them in sheet one.