Formulas can only return values to their calling cells rather than
copying to another cell, so one way:

Put this in Sheet2, cell A1:

=IF(Sheet1!E2="X", Sheet1!B2, "")

(assuming you meant B2 was in Sheet1 - change to suit).

In article . com,
Ed wrote:

I am looking for a conditional formuls to copy text to another
worksheet. For example if sheet 1 E2 is X than the text in sheet B2 is
copied to sheet 2 A1. I am new to excel so any help would be
appreciated.

Thanks