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

On Jun 27, 10:34 pm, EJ wrote:
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?