Returning value in secocolumn based on selected value in first col

K

Kicker

I am trying to set up a catalog look up in which the first collumn of the
worksheet1 is values selected from a named range in collumn 1 on worksheet3
(using data validation)

Worksheet 3 contains the following:
Collumn1 = list of part numbers - named range = Catalog_Number
Collumn2 = corresponding list of part names - named range = Part_Name

What I want to do is to have the 2nd collumn of worksheet1 automatically
completed with the corresponding part name based upon the value (part number)
selected in worksheet1-collumn1.

The idea is to allow a user to enter a part number in worksheet1:column1 and
the corresponding part name will be filled in automatically next to the entry
in collumn2

Can I do this without programming?

Thanks
 
T

T. Valko

Let's assume your drop down is on Sheet1 in cell A1.

To get the part name from sheet3:

=INDEX(Part_Name,MATCH(A1,Catalog_Number,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Insert name and adress from a list in a word document 1
Returning a Value from Another Worksheet 2
Drop down list control value in vba 2
Automatically populate value of cell dependent on adajecent cell 3
Counting rows based on the contents of multiple cells 2
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
Adding a big matrix in Word 2013 5

Top