Output value from information in multiple columns

Question

Hi All&nbsp;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.&nbsp;&nbsp;Thread coatingDiameterLengthPart number&nbsp;Thread coatingDiameterLengthPart numberHDGM61219054297&nbsp;HDGM620XXXHDGM61619055285&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM62019055544&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM63019083718&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM81219054823&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM81619053371&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM82019055048&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM82519053320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM83519077971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HDGM86019082304&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM6800122629&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM61013252577&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM61200110221&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM61419072724&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM61600101052&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM61800101060&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM62000101079&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM62200122688&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM62500101087&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM63000110191&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM64019105398&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM8800122696&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM81000101095&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM81200122645&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM81600101109&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM81819143303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM82000110256&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM82200101117&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM82500101125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM83000101133&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM83519127774&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM84019115601&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM84508063893&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM85019140746&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM86013288237&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM86519111975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM89013306510&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZincM810013302574&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

snake99 · Answer

Thanks a mil! I have not known the '&amp;"|"&amp;' part to be placed in a Vlookup, this helps a lot!

rachel · Answer

Snake99&nbsp;&nbsp;Hi,&nbsp;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.&nbsp;

Forum Discussion

Output value from information in multiple columns

2 Replies

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