Offset help

C

comotoman

formula'{=OFFSET(A42,MATCH(A2,LEFT($A$42:$A$658,LEN($A$2)),0) -1,0)}'

which works fine, but how do i show the next entry from the list in th
cell below
 
B

Bob Phillips

Do you mean

=OFFSET(A42,MATCH(A2,LEFT($A$42:$A$658,LEN($A$2)),0),0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top