How to determine the value within specific cell position?

[Eric]

I would like to retrieve specific cell based on the row() and column() numbers.

For example, if cell B5 contains text "Apple", which cell's position is
row()=1 and column()=2, so I would like to return the value into cell A1
based on the row and column number.

Does anyone have any suggestions on how to retrieve the value within
specific cell position?

Thanks in advance for any suggestions

 

[Don Guillett]

=b1

 

[Eric]

For example, if cell B5 contains text "Apple", which cell's position is
row()=5 and column()=2, so I would like to return the value into cell A1
based on the row and column number.

 

[Eric]

Do you know any excel function will return specific cell's value based on row
and column's positions?
Thanks in advance for any suggestions
Eric

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Bob I]

=B5