Creating a Sales Order with Drop Downs

[ExcelLover67]

Hello.

I have started to create a sales order. I have three columns that I will be working with. I have three lists in a separate worksheet (worksheet 2) in the same workbook. Column A has part numbers. Column B has descriptions of the part numbers in Column A. Column C has prices for the parts in Column A.

I have created a drop down list in Worksheet 1 from the list in Column A in worksheet 2. What I want to do is somehow link column B and C to Column A so that when an item is chosen from the drop down list, the information will pull through.

Any help is appreciated. Thanks!

[etaf]

use a vlookup or an index/match

so
if the dropdown is in A2 say
and in sheet2 the parts go to row 100 - (adjust as needed)
in B2 put

=Vlookup(A2, Sheet2!$A$1:$C$100,2,false)
copy down

in C2 put
=Vlookup(A2, Sheet2!$A$1:$C$100,3,false)
copy down

[ExcelLover67]

Book 2014.xlsx

Thanks, Wayne. It doesn't seem to work for me. I've attached (or I've attempted to attach) the Excel file. Perhaps you can take a look?

[etaf]

try this - see attached

[ExcelLover67]

Thank you, Etaf!! Fabulous! I appreciate the help!

[etaf]

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here