Firstly you should not be using a drop down list pointing to a list of 900
line items.

Rather, use an input cell that uses VLOOKUP to find the correct row and
column you are interested in using in your calculations (use exact lookup if
you want to restrict specific return values). Of course, your 1st column in
the 900 line item list will have to be sorted in some manner. I would put the
list in the same workbook as your drop down list. Finally, to restrict
erroneous user inputs, use Data Validation other than a Pick List.
--
Gnothi se auton.


"LittleAnn" wrote:

I am working on a worksheet that will have a drop down list. But the list I
need the list to come from is in another workbook that has 900 entries in it,
whats the fastest way to do this??