Try:

=LOOKUP(9.999999E+307,SEARCH({"Angle","Box","Channel","Flat","H-Beam","HSS","I-Beam","Pipe","Round Rod"},B4),{20,24,20,20,20,40,40,21,20})

Note: the first array has to be in ascending alphabetic order.

Make sure the corresponding numbers are correct in second array.