Hi,

was wondering what i need to do in excel to get this working:

i have two worksheets
1. is a transaction table
2. is a stock table

now i have got the stock items names into a drop down list on the transaction table and what i want it to do is when i enter a item on the transaction table from the drop down i want it to enter the price of the item which is part of the stock list

the items name starts in cell A2 and the price cell that i want updated start in H2 on the transaction list

the items name start in cell B2 and the price cell that holds the price value start on I2 in the stock table

any help would be much appreciated and i hope i have explained that well enough

cheers