=VLOOKUP(C12,$AA$7:$AB$34,2,FALSE)

Above is a function I have for columns C & D.
When I click on C12, a open Drop-down box opens, & I have to click on the
Down Arrow to bring up the list to pick from to get input to D12.
Is there a way to just input data into open box to get input to D12, instead
of scrolling down list, then selecting.
Hope this makes sense,
Thanx in advance.
peter-c.