1. Sort the list for the dropdown and put an A at the beginning of the A's,
B at the beginning of the B's... etc throughout the list to Z.

Type a letter in the dropdown cell and DO NOT hit enter. Click the arrow
and you will be at the top of that letters list. (You can hit Enter, but
then you have to re-select the dropdown cell)

2. Most likely an INDEX - MATCH formula. Something like this from a google
search, adapted to your ranges.

=INDEX(C2:E4,MATCH(A1,$C$1:$E$1,0),MATCH(A2,$B$2:$ B$4,0))

HTH
Regards,
Howard

"pblenis" wrote in message
...
I have a two part question.
1)how can i set up a drop down list using data validation that allows the
user to start typing in the first couple letter/numbers of what they are
trying to select and the list shrinks to fit those peramaters; for example
if
i had a list of 100 companies and someone typed S in the dropdown list,
when
they then clicked on the arrow only companies that start with an S appear.

2)I have a large spreadsheet Example with 200 rows and 50 columns, the
columns represent companies and the rows represent product numbers that
are 5
digits long. So each company/columns has a value for each row. I want
the
user to be able to be able to plug in the product number, then picking
from
the dropdown list of companies (using search in question) pick a company.
I
then want the corresponding value that corresponds to those two choices ie
is
row 2 and column 5 the i want E2 to populate into a selected cell. I know
how to use vlookup but how would i go about using it for two variables.
This
will all be on a seperate sheet.

Thanks