- Oct 11, 2007
- 29
- 0
- 61
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.
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.