Okay. i closed the workbook and reopened it, and it worked exactly right! Not sure what the problem was with the "N" column. Thank you again. Now my only question is how to make the drop down show the less than or equal to results. I played with it a little, but could not figure it out. I can get it to show the correct result in N2, but not in N3-N5000 - they all show blanks.