B1:B17 and C1:C17 are columns of data, not a row of data.

A formula cannot move cells as Ron stated. You must use VBA to move things
or enter a repeating formula.

In C1 of sheet2 enter

=IF(Sheet1!$A$1=1,Sheet1!B1,IF(Sheet1!$A$1=2,Sheet 1!C1,""))

Drag/copy down to C17


Gord Dibben MS Excel MVP

On Mon, 1 Jun 2009 15:53:01 -0700, DonE
wrote:

An example would be:

This IF Statement is in Sheet2 at C1

IF(Sheet1!A1=1,Sheet1!B1:B17,IF(Sheet1!A1=2,Sheet 1!C1:C17," "))

What I'm trying to do is based on a variable in Sheet one move a row of data
from sheet1 to sheet2 based on informatin in sheet1. The above example would
move 17 cells to this location on sheet2 from C1 to C17.

"Ron Rosenfeld" wrote:

On Mon, 1 Jun 2009 07:44:02 -0700, DonE wrote:

I have been trying to conditional move the contents of a spreedsheet within
an IF statement without any luck any answers?

A function can only return a value. It cannot move the contents of one cell to
another.

Perhaps if you could be more specific about what you are trying to accomplish
....
--ron