Adjacent cell, movement to


Good Afternoon:

A formula will move me to a specific cell. I then wish to retrive the
contents of an immediately adjacent cell. It does not matter if the
adjacent cell is to the left, right, above, or below the cell the
original formula move me to.

Example:

Orig formula moves me to B3. (could be any cell on the sheet)

Wish to retrieve contents of: B2 or B4 or A3 or C3.

Just wish to be consistent. Do it the same way each time the
original formula opens/lands on a specific cell.

Pls, how is this done?

Thank You,
Wayne
Sarasota
.

Relevant Pages

  • Re: Negative time displayed as #######
    ... But can you help me with the original formula? ... This would be easier to do with a helper cell. ... to "1904 date system" just so you can display negative time. ...
    (microsoft.public.excel.misc)
  • RE: Comparing Dates
    ... I am back at your original formula. ... "John" wrote: ... my first comparision is the difference between date 2 and date 1;d2-d1=c1, ... inot the cell. ...
    (microsoft.public.excel.misc)
  • Re: Inserting Formula into Array
    ... One thing you could do is put the VLOOKUP in another cell and then refer to ... Yes, its something like that, however the Dynamic Range slows things down ... manipulating the array, could result in a similar result without the slow ... From this: Original formula ...
    (microsoft.public.excel.misc)
  • Re: problem combining 2 formulas
    ... But now I wonder if your original formula is computing what you intended. ... "kinsey" wrote: ... The bank buy rate is 1.6706 (cell a1) ... The bank sell rate is 1.6085 ...
    (microsoft.public.excel.newusers)
  • Re: Coping formulas to new workbook
    ... the original formula. ... And I agree that it's a matter of preference. ... Hitting "Esc" drops the reference to the original cell ...
    (microsoft.public.excel)