Messed up - realized it right after clicking [post]. Put a $ sign in front
of the I in the formulas as
=IF(Sheet1!$I2...
That will keep that column reference from changing as you fill the formula
left to right across the sheet. The rest stays the same.

"Chey" wrote:

I have my general information on a sheet in Excel. I have a colum "I", that
I am going to put a X in. So on sheet 2 I want only the rows that contain X
in column I to carry over. I am not sure if this is one of the lookups or an
if statement.
Thanks
Cheyenne