Copy and Paste based on Condition

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
nested IF without repeating the condition to be tested 6
Copying based on a condition 2
Copy Paste conditional formatting 2
Case Statement Format for getting cell value from a worksheet 1
Sumif function with a date range condition statement 4
How to determine the minimum value with given condition? 2
If condition with text 3

Top