hi all, if my data is as shown below, and i want to choose only the row data
from my surace designation selection into the formula. The formula will only
reference to the cell values of that row once i chosen my surface des. For
example: select suface 2, then the formula ex: qqq=fin area x surface area =
B3xC3
then make another surface selection, qqq= B? x C?.
how do i make my formula reference with the row data of that particular row
that i chosen?

hope someone can help. do reply if unsure about what is my senerio so that i
can make it clearer. thanks


surface designation fin area surface area
... ....
2 5
1
1.5 6
2
2.5 10
5
6.0 15
9 .
.. .
. .
.. .
. .
..

hi all, if my data is as shown below, and i want to choose only the row data
from my surace designation selection into the formula. The formula will only
reference to the cell values of that row once i chosen my surface des. For
example: select suface 2, then the formula ex: qqq=fin area x surface area =
B3xC3
then make another surface selection, qqq= B? x C?.
how do i make my formula reference with the row data of that particular row
that i chosen?

hope someone can help. do reply if unsure about what is my senerio so that i
can make it clearer. thanks


surface designation fin area surface area
... ....
2 5
1
1.5 6
2
2.5 10
5
6.0 12
3
..
..
..

sorry my previous message got problem. hope this one wont run