IF formula only showing positive results

[Davidm]

I want to look up a column on another worksheet to look for a code and then
copy information from that row into the new worksheet. I am using a IF
formula at present but I want the correct answers at the top of each page. Eg
code =2 on sheet2 code =3 on sheet 3 but want the aanswers at the top of page
instead of having blank rows. Hope you can understand what I'm asking

 

[Fred Smith]

Your post is very difficult to understand. You can help by:

1. Post the If statement you are using.
2. Tell us what results it gives you.
3. Tell us what results you want to see instead.

Regards,
Fred.

 

[Davidm]

This is the formula I am using at present =IF(Sheet1$A2=1,Sheet1B2,"") this is
giving me the right answer if A2 =1 but if I copy this down to the next few
rows and B2=2 then the anwer will be "" which leaves blank rows until the
next 1 is found in Column A of sheet 1 then it puts the correct answer in. I
was wondering if I could change my formula so that the rows are elimated that
have "" in them or do I have to sort Sheet 2 to bring the positive answers to
the top of the page