Once you have used the Data Validation drop-down to select an item from the
list, use the =VLOOKUP() function to get the price from an adjacent column.
--
Gary''s Student - gsnu200823


"shaky_uk" wrote:

I have created a drop down box from another worksheet. What i want to happen
is when the data from the list is selected excel then pastes data into
another cell.
In the drop down list is a list of descriptions when one of these is
selected i want to link to the corresponding price and paste it to a cell.
for invoicing purposes is this possible?