You can use a scrollbar ActiveX control (Tools|Customize...|Toolbars,
check the Forms toolbar).

Draw the scrollbar on the sheet, double-click to format and set a Cell
LInk. Then your HLOOKUP() can tak 3rd argument from the cell.

HTH
Kostis Vezerides