If only numbers appear in column H try =IF(B1=1,H1,0) in cell K1 then copy down
This will cause a zero to appear in column K where number in column B is not 1
If you do not want a zero to show go to TOOLS, OPTIONS, VIEW and untick Zero
values.
Alternatively if you are entering letters or other symbols in column H you
could try =IF(B1=1,H1,"") in cell K1 and copy down. Hope this helps.



"Colin Hayes" wrote:


HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.