How can i get a IF formula to skip to the next reference box
 

I have a "IF" formula which looks up a cell on another worksheet, if the cell
has a value it returns another cell's value with in that work sheet, to the
previous cell with "IF" function in. The cells in the colum in wich i
reference from will change from no data to 1 or etc.

I want to drag the information down the work book but avoid the the null
value wich will appear like so.

code desc qty price
KATUR cat flap 1 £300
KATURB black cat flap 2 £900

not what im getting now

code desc qty price
KATUR cat flap 1 £300
-------- ----------- - -----
KATURB black cat flap 2 £900