Returning value in secocolumn based on selected value in first col
 

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

Returning value in secocolumn based on selected value in first col
 

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))


--
Biff
Microsoft Excel MVP


"Kicker" wrote in message
...
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