Lookup condition

Hello,

I have two column of data colA and colB. data in colB includes 0 and other numbers. i would like to use a function on colC and colD that IF colB is bigger than 0 then insert the value of ColA in ColC and insert the value of colB in colD but I don't want to have any gaps between cells. Any ideas?

I have attached an axample file which what do I expect to get!

Thanks

it is a little difficult to tell what you are trying to achieve but guessing at the possible different scenarios you might want to try this in cell C2 =IF(B2>0,A2,0) and this in D2 =IF(C2<>"",B2,0) but I suspect you may actually need something done in visual basic.

Well obviously that is a more complex formula than I was considering. FOR ME (maybe not so for some others) it is difficult to tell how your data appears and how the "gaps" may show up depending on what you are doing so I'll say it again, attaching a spreadsheet with examples of what you have and what you want would go a long way toward getting a better answer.