Vlookup

double click? why? i think you need to post an example.

When you double-click the lower right corner of a cell it acts like an automatic fill-down. This only works when there is data in the cells immediately to the left or right of the cells you're trying to auto-fill. If, for example, you had data in C1:C10 and C12:C20 and you entered a formula into D1. You could double-click the lower right corner of D1 and it would auto-fill the formula down to D10. It would stop there, because there is no value in D11. You would manually have to copy the formula to D12, and then you could double-click again to fill the rest of the way down to D20.

This functionality cannot be altered that I'm aware of, but if you wanted you could create a macro to run via the DoubleClick event to fill down values/formulas.. only problem is how would the macro know when to stop? Would it always base the "last row to fill to" on two columns to the left? Seems like more work than necessary to just click on the lower right corner of D1 and drag your mouse downward to the bottom of your data (or select D1:D?? and use Fill -> Down).