J
Jared
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.
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.