Using IF function to copy.

D

Dev_prashad

How can I copy data from one cell to another only if a certain criteria is
met using the IF function? For example, I want to copy data from cell A20 if
the cell A19 the a specific word in it.
 
M

Max

Something like ..

In B20: =IF(A19="Yes",A20,"")

B20 will return the contents of A20
if A19 contains the word: Yes,
otherwise blank: "" will show in B20
 

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

Excel - Wich Function should I use? 1
Pasting a cell into bookmarked table from excel vba 1
Need Help with a VBA subroutine 0
Extracting data/using COUNTIFS 2
Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0
Excel does not accept text format! 0
Matching Values of 1 row vs all other rows. 0

Top