David,

You can use columns() and rows() to work out where cells are located.

It is a little difficult to understand what you want may be an example would
help

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"David Virgil Hobbs" wrote:

I want to know how a certain Excel formula would be written.

Excel formulas reside in cells computing the value of the cell content.
A given formula can be entered in an entire column, producing different
values in each cell in the column in which the one given formula is
entered.


The desired formula would, based upon the distance in worksheet A of a
given cell G that the desired formula resides in from a starting point
cell S in worksheet A, reference a cell R in worksheet B, that is a
certain distance from a starting point cell BS in worksheet B, and use
the value in the referenced cell BS in worksheet B to produce a value
for the given cell G in worksheet A.

Definition

Distance: a cell can be a given number of rows away from a cell in its
own column; a cell can be a given number of columns away from a cell in
its own row.

Help sections do not seem to answer the two basic questions: 1 Is the
software able to do a given thing? 2 How is the given thing to be done?
Time is wasted simply determining if a software can even do something
in the first place.