Fixed reference in Excel 2007 table formula

[rolito]

I have a formula in Excel 2007 table like this:

=[Quantity]*[Price-Jan-08]

I would like to copy that formula to the right with quantity absolute fixed and Price been relative.

In Excel 2003 I used the "$", but in this new Excel 2007 table formulas I don´t know how to copy this formula to the right and let it change to:

=[Quantity]*[Price-Feb-08]
=[Quantity]*[Price-Mar-08]
.....

Any suggestion on how to fix the [Quantity] when copying to the right?

Thanks a lot for your help !

 

[Yard]

=INDIRECT("Table1[[#This Row],[Quantity]]")*Table1[[#This Row],[Price Jan-08]]

Or just revert to cell references!

 

[rolito]

Awesome answer, the indirect works very fine !