Conditional Formula

[Ed]

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

 

[JE McGimpsey]

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).

 

[Ed]

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).




- 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?