I have been using Excel 2007 to analyze some data that comes in long, narrow worksheets. The first column A will have values such as (e.x. row 1=0000, row 2=0030, row 3=0040,...etc) with a corresponding value for each entry in the second column B (e.x. row 1=500, row 2=1200, row 3=500). I would like to know if I could insert a command in top of Column C that says if 000 is present in any row of Column A, then send the value, in this case 1500, to same row in column C?

Thanks in advance for your help

AlC