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
Bookmarks