On sheet 1 select two cells in the same row and while selected type in this
formula and the use CTRL + SHIFT + ENTER to commit.

=VLOOKUP(A1,Sheet2!A1:C30,{2,3},0)

The lookup ISBN number is in sheet 1, A1.
On sheet 2 column A is the ISBN numbers, column 2 is the Description and
column 3 is the Price.

If you alter the formula you will have to select the 2 cells with the
formulas, make your changes and Array Enter again, useing CTRL + SHIFT +
ENTER.

HTH
Regards,
Howard

"daviebutton" wrote in message
...
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