vlookup help
 

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

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

wrote in message
.. .

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

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,$A A$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!
==============================================


wrote in message
.. .

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