I have a worksheet that lists parts, with all there required date in one sheet, in the next sheet i have a material grade and a price that is pulled through from a different work book.

Within the first sheet i have a drop down box that when the grade selected the price populates the next cell, simple V-Look up apparently.

The problem with this is there are hundreds of parts that use the same material grades, but it wont allow duplicate prices from the VLook up, how can i get around this?

Thanks