Retrieve contents of a neighboring cell

[wgd.roaming]

A formula "lands me" on a particular cell.

I would like to automatically retrieve the contents of an immediately
neighboring cell.

For instance, the formula "opens" B3 (a "find" function for example,
incorrect semantics here??). I would like to automatically retrieve
the contents of C3.

Thank You.

Wayne

 

[Ron Rosenfeld]

A formula "lands me" on a particular cell.

I would like to automatically retrieve the contents of an immediately
neighboring cell.

For instance, the formula "opens" B3 (a "find" function for example,
incorrect semantics here??). I would like to automatically retrieve
the contents of C3.

Thank You.

Wayne

Not sure what you mean by "lands me".

A "formula" or "function" in Excel can only return a value. It does not return a cell reference ordinarily, nor can it return the "contents" of a cell; only the value that is in that cell (although with User Defined Functions, you can return the actual contents of a cell as a string, and could even return the cell reference), and with the MATCH function, you could develop a cell reference.

If you have some formula which returns a value that matches the contents of some cell, you can probably use either VLOOKUP or a combination of INDEX(MATCH( ... to return the value in an adjacent cell.

Details of exactly what you are trying to do would be helpful in trying to craft a more appropriate solution.

 

[Michael Bednarek]

A formula "lands me" on a particular cell.

I would like to automatically retrieve the contents of an immediately
neighboring cell.

For instance, the formula "opens" B3 (a "find" function for example,
incorrect semantics here??). I would like to automatically retrieve
the contents of C3.

Others already queried what you might mean by "a formula landing me on a
cell"; my question is, what do you mean by "retrieve"? What do you want
to do with the contents of cell C3?

 

[wgd.roaming]

Michael:

Wish to take data found in the adjacent cell and place it on a form.

Problem is driven by a cut 'n paste of data, a page from another
application where the name/address fields vary in terms of number of
rows. Address fields in one case might be one line, in another case,
two lines, etc. The result is the "find name" found in one cell will
be up/down by one-two rows compared to the absolute row when "find
name" ends up on another row.
Am I being so difficult? Hard to understand? If so, pls say so.

Thank You for your help and understanding.

Best Regards,
Wayne