Hello,
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category.
=LOOKUP(9.99999999999999E+307,SEARCH(" "&MOC&" "," "&$C2),CODE)
But it returns to #N/A.
<tbody>
<tbody>
PIPE SIZE, 20NB, SCH STD, ASTM A106 GR.B, PE...