Spreadsheet help please

[Shane]

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

 

[Tom Hutchins]

Debra Dalgleish explains how to do this on her wonderful Contextures site:
http://www.contextures.com/xlDataVal02.html

Hope this helps,

Hutch