I have the following, in cells
A2 = Part Number B2 = Description C2 = Supplier D2= Lead Time E2 = Number
req F2 = Qty
What I,m trying to acheive is that in cell C3 there is a drop down menu that
you can pick one of 7 suppliers, depending on which one you chose i want it
to populate a requirement in D3
Is this possible, if so can you explain how

Thanks