If a cell contains chosen text, add value from another cell to chosen cell

Hello. I'm a new member and hope I follow the rules...

Using Excel 2007, in a selected cell (on another worksheet), I would like to enter a function (?)...If the chosen cell on the other worksheet contains certain text, add the text that appears in another cell on the same row. (Eg. In cell A2 on worksheet 2: If there is the text "Da" in cell A5 on worksheet 1, then return the text that appears in cell A2 on worksheet 1.) Is this doable?

thank you

Put this formula in A2 of Sheet2:

=IF(ISNUMBER(SEARCH("Da",Sheet1!A5)),Sheet1!A2,"")

Not sure that you meant to return the text from Sheet1!A2 - did you mean A5 ? (If so just change the reference).

Hope this helps.

Pete

Pete: Thank you for your quick response and it's bang on!

To expand on this question, can I expand a reference to look for certain text in a range of cells and return the text in a cell from the corresponding row? So the formula in A2 of Sheet 2 would possibly look like:
=IF(ISNUMBER(SEARCH("Da",sheet1!F5:F12)),sheet1!B5:B12,"")

Thank you.

I think it's time to post a sample workbook, where you can explain more clearly what you want to achieve. The FAQ above gives details of how to attach a file to one of your posts.

Hope this helps.

Pete