Forum Discussion

Snake99's avatar
Snake99
Copper Contributor
Oct 31, 2023

Output value from information in multiple columns

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 wi...
excel
Formulas and Functions
rachel's avatar
rachel
Steel Contributor
Nov 01, 2023

Snake99 

 

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.

 

 

 

Snake99's avatar
Snake99
Copper Contributor
Nov 01, 2023
Thanks a mil! I have not known the '&"|"&' part to be placed in a Vlookup, this helps a lot!