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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

wrote in message ...
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.