Excel Function Help

[ColtMaverick]

I have studied the help section thoroughly to see which funtions (nested as well) would apply to the data I am trying to use. However, all my attempts at finding a successful combination have failed.

My goal is to set up a cell that will select a part number for a specific sheave based on three cells. These three cells will be manually input data that must be compared against a table to determine what the part number will be.

I will attempt to show the layout below.

(Diameter Cell), (Bushing Cell), (Type Cell) = Part Number

Where data is in worksheet as shown below (P.S. I can't find an attachment option for spreadsheets. Let me know if one exists.)

Type | Bushing | Diameter | Part Number
2C SD 5.6 A1234
2C SF 7 B1234
3C SD 5 C1234
3C SF 6 D1234
3C E 8 E1234

This data goes on for over 258 part numbers which can result in a ton of combinations. Please help me by telling me what functions to use and the nesting order they should be in. I've tried a combination of IF, AND, and VLOOKUP to no avail. Thanks in advance.

 

[petesamprs]

Why not create an identifier for each part number by combining each piece of data? For example: in an adjacent column put "=A1&B1&C1", which will give you 2CSD5.6 for the first entry. Copy that down for all parts, and you'll have a unique identifier for each part. Then just combine the user inputted data in similar, and use a vlookup to find its associated part number.

Another alternative is to use autofilters and select each piece of data from a pull down to get to the part number