I would like to create a spreadsheet that uses a formula that recognizes a word in one column to add avalue to another column. Can anyone help?Hang in there some one will help. It's over my head  Your question is skimpy on details?  Can you ELABORATE, maybe GIVE an example?Yes,
If you look below and imagine it is an Excel spreadsheet, I would like for the formula to see if column 1 contains the word crane or runway I would like for VALUE 24 (for runway) and 4 (for crane) to be automatically added to column C.
       
  A                            B               C              D              E              F
     Descpition          Qty           HRS Per     Total Hrs   Rate       Total
 1 38' runway   2   24   48   70   3360
 2 20' span crane   1   4   4   70   280
It didn't post exactly the way it previewed. If you add spaces to the values to line them up with the letters across the top it will make more sense.Try it with this formula in column C.

Code: [Select]=IF(NOT(ISERROR(SEARCH("runway",A2,1))),24,IF(NOT(ISERROR(SEARCH("crane",A2,1))),4,""))trusky, where do you stand on this now?  Was the formula posted by oldun HELPFUL?  I was thinking the VLOOKUP function is what you need.