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