Next Referenced Cell

[JohnL]

I am trying to get a generalised next referenced cell in a column o
numbers in a worksheet and I am stumped.
For example

A1 62
A2 23
A3 44
A4 56
A5 45
A6 44
A7 12

B6 =(A3) C6 =(A1) D
=(A6)
B7 =Value of C7 =Value of D7 = Valu
of
Next Next
Next
Referenced Referenced
Referenced
Cell Down Cell Down Cel
Down
56 in this case 23 in this case 12

(A4) (A2)
(A7)

So I can replicate this across a 100 or so cells

thanks in advanc

 

[Bob Phillips]

John,

Does this B6 example do what you want?

=INDEX(A:A,MATCH(B6,A:A)+1,1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)