Oct 31 2023 11:57 PM
Hi All
I am needing some assistance in figuring this out. Currently I have a table with multiple criteria that I need to use to output a part number. For the attached example, I have 3 columns with specific criteria and need to output the part number in the 4th column. What will eventually be on another sheet, I will have the required bolt specifications for Thread coating, diameter and length and need to pull the part number through these are depicted to the right of these columns. Where XXX is, I am wanting to pull the part number value through from the 3 cell values next to it. Currently using Excel 2016 at work which I need the formula to work with.
Thread coating | Diameter | Length | Part number | Thread coating | Diameter | Length | Part number | |
HDG | M6 | 12 | 19054297 | HDG | M6 | 20 | XXX | |
HDG | M6 | 16 | 19055285 | |||||
HDG | M6 | 20 | 19055544 | |||||
HDG | M6 | 30 | 19083718 | |||||
HDG | M8 | 12 | 19054823 | |||||
HDG | M8 | 16 | 19053371 | |||||
HDG | M8 | 20 | 19055048 | |||||
HDG | M8 | 25 | 19053320 | |||||
HDG | M8 | 35 | 19077971 | |||||
HDG | M8 | 60 | 19082304 | |||||
Zinc | M6 | 8 | 00122629 | |||||
Zinc | M6 | 10 | 13252577 | |||||
Zinc | M6 | 12 | 00110221 | |||||
Zinc | M6 | 14 | 19072724 | |||||
Zinc | M6 | 16 | 00101052 | |||||
Zinc | M6 | 18 | 00101060 | |||||
Zinc | M6 | 20 | 00101079 | |||||
Zinc | M6 | 22 | 00122688 | |||||
Zinc | M6 | 25 | 00101087 | |||||
Zinc | M6 | 30 | 00110191 | |||||
Zinc | M6 | 40 | 19105398 | |||||
Zinc | M8 | 8 | 00122696 | |||||
Zinc | M8 | 10 | 00101095 | |||||
Zinc | M8 | 12 | 00122645 | |||||
Zinc | M8 | 16 | 00101109 | |||||
Zinc | M8 | 18 | 19143303 | |||||
Zinc | M8 | 20 | 00110256 | |||||
Zinc | M8 | 22 | 00101117 | |||||
Zinc | M8 | 25 | 00101125 | |||||
Zinc | M8 | 30 | 00101133 | |||||
Zinc | M8 | 35 | 19127774 | |||||
Zinc | M8 | 40 | 19115601 | |||||
Zinc | M8 | 45 | 08063893 | |||||
Zinc | M8 | 50 | 19140746 | |||||
Zinc | M8 | 60 | 13288237 | |||||
Zinc | M8 | 65 | 19111975 | |||||
Zinc | M8 | 90 | 13306510 | |||||
Zinc | M8 | 100 | 13302574 |
Nov 01 2023 12:31 AM
Hi,
I think you just need to create a key that contains "Thread Coating", "Diameter", and "Length" to use as a lookup key for "VLOOKUP" function.
I attached an example excel file.
Nov 01 2023 12:58 AM