Forum Discussion
connerh99
Apr 07, 2021Copper Contributor
Search through a string of text for a specific value and relate it to a horizontal value
I am trying to create a script that allows me to type in the unique ID in a cell and have it spit out the value of the product name in the horizontal row corresponding to the unique ID. The main catc...
JMB17
Apr 07, 2021Bronze Contributor
For one thing, your formula has "IANUMBER" instead of ISNUMBER and is why you are getting #NAME.