Getting data from another sheet

[JcLudden]

How would I get the data I need from another sheet, if a column contains a certain text I want to add the value in the next column.

[#2]

Have you tried the VLOOKUP formula?