Formula

Hello,

If user enters a value greater than zero in a given cell
then the cell is equal to the value in Staff!D2.
The problem I need the Staff!D2 to stay constant when I
drag the formula to other cells. See below:

This what I do when I drag the formula down:
=IF(C130,Staff!D2,"")
=IF(C140,Staff!D3,"")
=IF(C150,Staff!D4,"")
=IF(C160,Staff!D5,"")
=IF(C170,Staff!D6,"")

This is what I want it do:
=IF(C130,Staff!D2,"")
=IF(C140,Staff!D2,"")
=IF(C150,Staff!D2,"")
=IF(C160,Staff!D2,"")
=IF(C170,Staff!D2,"")

I know I can go to each cell and change the Value_if_true
to Staff!D2 but I would have do this for thousands of
cells.

I was just wondering if there is an easier way to have the
Logical_Test change like it is suppose to (ie C13, C14,
etc) but the Value_if_true stay the same (ie Staff!D2).

Or is there way to come back and change all the
Value_if_true to Staff!D2.

Thanks for any help.

Robert,

You simply can "anchor" the column, column # 2 in this case
Do this via dollar sign, e.g. Staff!D$2

cheers,
Kolyan
-----Original Message-----
Hello,

If user enters a value greater than zero in a given cell
then the cell is equal to the value in Staff!D2.
The problem I need the Staff!D2 to stay constant when I
drag the formula to other cells. See below:

This what I do when I drag the formula down:
=IF(C130,Staff!D2,"")
=IF(C140,Staff!D3,"")
=IF(C150,Staff!D4,"")
=IF(C160,Staff!D5,"")
=IF(C170,Staff!D6,"")

This is what I want it do:
=IF(C130,Staff!D2,"")
=IF(C140,Staff!D2,"")
=IF(C150,Staff!D2,"")
=IF(C160,Staff!D2,"")
=IF(C170,Staff!D2,"")

I know I can go to each cell and change the Value_if_true
to Staff!D2 but I would have do this for thousands of
cells.

I was just wondering if there is an easier way to have
the
Logical_Test change like it is suppose to (ie C13, C14,
etc) but the Value_if_true stay the same (ie Staff!D2).

Or is there way to come back and change all the
Value_if_true to Staff!D2.

Thanks for any help.

.