have you tried
=IF(Sheet1!A11,Sheet1!A1,"")


--
Don Guillett
SalesAid Software

"Catherine Bond" <Catherine wrote in message
...
Hi,

I am trying to set up a spreadsheet where you input master data on Sheet1,
then depending on what options are not checked off (with an 1), that row
of
data will not appear on Sheet2.

I thought the easiest way would be to create an If statement, something
like:
=IF(Sheet1!A11,Sheet1!A1,do not display this line at all)

Obviously, that doesn't work! Is there a function that will allow this to
happen?

Also, in the "VAlue_if_TRUE" spot, is it possible to tell it do display 2
cells of data?

Thanks!!!