Hi All,

I am struggling to solve a task I require for my work. To put it simply I need to know how to do the following. In sheet 1 when I select an item from a drop down list in A1 I need it to auto fill the items price in B1. All the relevant data is on sheet 2. I understand how to create the drop down list but don't know how to make the price cell pull the item price from the data in sheet 2 based on the name of item?

I hope this makes sense?

Thanks in advance