How to set up easy lookup methods
 

Sorry, having trouble understanding $A etc

How to set up easy lookup methods
 

OK, try the following.

The $A1 reference means that column A is locked or fixed. This means that if
you copy a formula, to the right, it will alsways use the values from column
A, but copying down, it will move down the row references.

If it read A$1, then it means that Row 1 is locked. If you copy the formula
down rows, it will always use the cells from the row. If you copy the formula
o the right, the column references will update

Setup a sheet looking like this
A B C D
1 10% 20% 30%
2 10 =$A1*b$1
3 20
4 30

Copy the formula down and to the right, and look at the column and row
references

Hope this helps
Eddie
--


"ET" wrote:

Sorry, having trouble understanding $A etc

How to set up easy lookup methods
 

Just to add to Eddie's comments, its called Absolute Reference. In B1 type
in =A1 and before you hit enter, hit F4 four times slowly and your formula
will toggle through all the absolute references possibilities.

HTH
Regards,
Howard

"ET" wrote in message
...
Sorry, having trouble understanding $A etc