Can I use the active cell as an input to a formula?

Hi all,

I was wondering if I can use the active cell, by that I mean the cell that is "highlighted" at a given time with the square border after there was a mouse click there, as an argument in a function.

For example, I have created a table with weighted averages with 3 weights: w1 is given in the column headers (kindly see attached file), w2 in the row headers, and w3 which complements w1 and w2 to 1.

What I'd like to do is have cells outside the table show the weights the average got when a cell in the table is selected.

For example:
pic_for_question.PNG

Here we see the cell K12 is active,
and for K12 w1=0.2, w2=0.15, and so, the cells in the weights tables above (rows 3-4) get the appropriate values according to the weights in the active cell.
(of course I manually created this one for illustration purposes)

Is there a way to do that? Preferably without VBA if possible
Couldn't find anything very useful...

Thanks in advance!
A

question_active_cell.xlsx

(the values inside the table are random values...)

I would love it if you could show me how to do it with VBA...

can u please show it in a formula instead of a pop up message?
tnx

I mean in the file itself.... when i select a cell a pop up comes on,
I'd like to see how the active cell can be used inside a formula.

Would be amazing if you could take a look at the files I attached to the original post (excel file & pic). Basically I want the value of the active cell to be an input in a formula (given in a different cell)