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

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

On Jun 6, 12:07 pm, JE McGimpsey wrote:
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- Hide quoted text -

- Show quoted text -

Thanks that worked, to take it a step further can I do that for the
entire workbook, If Sheet 1 E3 is X than text from Sheet 1 B3 would go
to sheet 2 A3 and so on, instead of putting in the formula hundreds of
times?