Hi All,
I am using a separate 'quick reference' sheet and looking to use (3) DropDown menus in order to triangulate a "Part Number" in a table on another sheet.
The vital information needed to find this "part number" is:
1. Length
2. Color
3. Packaging Type (i.e. SIngles OR Bulk Bundles)
My data table begins at B6 and goes to K42
My original formula to find the "part number" with (2) dropdown menus was:
=INDEX('Copper Patch-Assemblies'!E7:K42,MATCH(Index!C42,'Copper Patch-Assemblies'!C7:C42,0),MATCH(Index!D42,Colors,0))
the first picture below is of the data table where i am pulling data from. The second is the 'index sheet' where the (3) dropdown options are selected in green and "part number" formula in yellow.
How can this be done Where the "Part Number" is found only by selecting the (3) attributes listed above?
I am using a separate 'quick reference' sheet and looking to use (3) DropDown menus in order to triangulate a "Part Number" in a table on another sheet.
The vital information needed to find this "part number" is:
1. Length
2. Color
3. Packaging Type (i.e. SIngles OR Bulk Bundles)
My data table begins at B6 and goes to K42
My original formula to find the "part number" with (2) dropdown menus was:
=INDEX('Copper Patch-Assemblies'!E7:K42,MATCH(Index!C42,'Copper Patch-Assemblies'!C7:C42,0),MATCH(Index!D42,Colors,0))
the first picture below is of the data table where i am pulling data from. The second is the 'index sheet' where the (3) dropdown options are selected in green and "part number" formula in yellow.
How can this be done Where the "Part Number" is found only by selecting the (3) attributes listed above?