vlookup help

[peter-c]

=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.

 

[Ken Wright]

Assuming it is a Data Validation list then just type it in? What kind of
list is it?

 

[RagDyeR]

Don't know if I understand exactly what you're asking.

If the drop-down list was created using Data Validation, and you wish to be
able to by-pass the restrictions, select the cell (C12), then:

<Data> <Validation> <ErrorAlert> tab,
And *UNCHECK*
"Show Error Alert" box.

If, on the other hand, you wish to be able to have a choice of either using
the drop down list, or another "box" (cell), you could try this formula,
where the "open box" is cell C11:

=IF(ISNA(MATCH(C12,$AA$7:$AA$34,0)),VLOOKUP(C11,$AA$7:$B$34,2,0),VLOOKUP(C12
,$AA$7:$AB$34,2,0))

This formula gives the preference to C12, meaning, if both C11 and C12 have
data, C12 will trigger the return.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



=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.