formula help - cell reference constant even if cell is moved

Is it possible to have one cell (b1) reference another cell (a1) where the reference in (b1) is constant (a1) even if I move a1?

Currently, if I move a1 the reference in b1 moves to where I moved a1 to.

Using excel 2010.

Thanks.

Bruce

Appreciate the response.

Can you tell me what the =5,7,10 refers to?

Bruce

P.S. I plugged in the formula and the result was 10.

It's just saying that if A1=5, then B1=7, else B1=10.

Got it.

I'll work on it after dinner.

Thanks.

I finally figured it out and thanks for starting me in the right direction.

Here's what I ended up with:

=SUM(INDIRECT("$j$12:j12"))

Thanks again.

Bruce