Copy and Paste based on Condition

E

EJ

If a condition is true in a colum or series, I would like to grab a value in
another column and place it in a given cell in another tab.

Can anyone help with this?
 
P

Pete_UK

A formula can only be used to return a value to the cell in which it
is placed - it cannot "push" a value to another cell. So, you will
need a formula in the cell where you want this value to appear, along
the lines of:

=IF(the_condition_is_true,Sheet1!A1,"")

which assumes you want to get the value from A1 in Sheet1 - adjust as
necessary.

Hope this helps.

Pete
 
Top