Searching for a string and input value

[jalweber]

Hi Again All,

I have come across one final problem with my worksheet which is attached...

On the TakeOFF sheet, column C I need to have a seach for a string in the corresponding row of column B, depending on what that finds it needs to put in a different number value for each of the search strings.

I thought I had accomplished this through a VERY nasty nested IF statement. Basically it searches for the following terms and inputs the corresponding number.

Angle - 20
Box - 24
Channel - 40
Flat - 20
H-Beam - 40
I-Beam - 40
Pipe - 21
HSS - 20
Round Rod - 20

Any help at all is appreciated! I'm so close!

Thanks in advance