Retrieveing data from a neighboring cell

[wgd.roaming]

A formula will find a cell on a sheet. (Easy part)

Once there (location not known beforehand), how do I retrieve data
from a cell immediately below?

Am I being clear?

Thank You
Wayne

 

[Ron Rosenfeld]

A formula will find a cell on a sheet. (Easy part)

Once there (location not known beforehand), how do I retrieve data
from a cell immediately below?

Am I being clear?

Your question is clear, but the amount of information is insufficient for me to craft a response.

How are you determining the location, especially the row? What you would do is add one (1) to that result so it would point to the next row down. One way is to compute the row parameter using a combination of INDEX(MATCH(...