Offset help

[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 the cell below?

[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)

"comotoman" <[email protected]> wrote
in message news:[email protected]...
>
> 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 the
> cell below?
>
>
> --
> comotoman
> ------------------------------------------------------------------------
> comotoman's Profile:
http://www.excelforum.com/member.php...o&userid=27292
> View this thread: http://www.excelforum.com/showthread...hreadid=495259
>