Data Validation Lookup List from Another File

[mjones]

Hi,

Without duplicating the cell contents in the current spreadsheet (call
it Template), is there anyway to have a dropdown list of items
(starting in cell T38 and going down to T45) from another file
([Price_List.xls]License_Only!C2 to C whatever row which will change).

Then, when the item is selected from the list in T38, lookup the cell
to the left in row D of Price_List.xls and put it in S38.

The reason I don't want to duplicate the cell contents in the current
spreadsheet is because the file will be way too large to deal with.

I hope that explains it well enough

Thanks for any help you can offer.

Michele

 

[Roger Govier]

Hi Michelle

take a look at Debra Dalgleish's site for lost of information on data
Validation.
In particular, look at Create Dynamic Range from another workbook
http://www.contextures.com/xlDataVal05.html