Hi,

I hope someone can point me in the right direction !
My workbook has a number of sheets as below.

On my product list sheet I have a list of suppliers, some UK and some USA
based, I have used a data validation list to allow the salesmen to select a
product and display the cost =VLOOKUP(A20,partslist,2,FALSE)

On the sales sheet I have two columns, A: USA list price B:UK list price I
need to put the right cost in the correct column.

Thanks for any help you can give.

Jared.
--
New excel user, please pass !