When using the VLOOKUP function in Microsoft Excel (2002 version I think), I am able to produce a drop down box. However, I am not able to use the mouse wheel to scroll. Is there a setting I'm missing that will allow that or is it a limitation of Excel?

I know under Options > General there is an option to use the mouse wheel to zoom but that's not what I'm looking for. I want to be able to scroll up and down on the vlookup drop down.

Thanks.

As far as I know, it isn't possible to use the mouse wheel to scroll inside an Excel drop down list...