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" wrote in message
...
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