Excel if/then formulas

[trusky]

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?

[ganjaman]

Hang in there some one will help. It's over my head 

[soybean]

Your question is skimpy on details?  Can you elaborate, maybe give an example?

[trusky]

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

[trusky]

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.

[oldun]

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,""))

[soybean]

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.