Hi

On sheet 2 I have a 13 digit code in Col A, the description in Col B and the
price in Col C, these will be constantly added to manually.

On sheet 1 I would like possibly a 'drop down list' of the 13 digit codes in
column A, then for Col B to auto fill the Description and Col C to fill the
price. Is this possible?

In other words sheet 2 comprises of the data for the ISBN numbers, plus
description plus price, which will over time be added to. On sheet 1, its the
orders taken, so if the ISBN is put into Col A, then col B and Col C are
filled from the data on sheet 2.

I hope this makes sense?

Thanks
Dave