Pull Down Absolute Table Reference

Can anyone please help me understand how to create two tables then use an absolute reference to a cell in one table to drag down in a formula with the other table?

I have searched online for answers, but can only find how to drag a formula across columns, but cannot get it to drag down.

Attached is an example where I have just created a "Times Table" by creating a table [Number] in column A to hold a set of numbers, then another table [Times] in column C to hold a single number, then to use columns E and G to create the drag down formulas.

In column E I just make a simple formula to multiply the two columns: =A2*$C$2 which can easily be dragged down, but in column G when I reference the tables, I can use =Number[@Number]*Times[@Times] but cannot find how to create an absolute reference that I can drag down without getting a #VALUE! error.

Thanks in advance.

Like this, do you mean??

=Number[@Number]*Times[Times]

Lol.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.