Formula
{=OFFSET($A$42,MATCH($A$2,LEFT($A$42:$A$800,LEN($A $2))-1,0)-1,0)}

What I need is a "Next" and "Prev" Button. Right now I have "+1" button

{=OFFSET($A$42,MATCH($A$2,LEFT($A$42:$A$800,LEN($A $2)),0)-1,0)}

"+2" Button
{=OFFSET($A$42,MATCH($A$2,LEFT($A$42:$A$800,LEN($A $2)),0)+1,0)}

And so forth.... I am using Excel 2003
Vb code for cmd buttons

Sub PlusOne()

Range("B2").Select
Selection.FormulaArray = _
"=OFFSET(R42C1,MATCH(R2C1,LEFT(R42C1:R800C1,LEN(R2 C1)),0),0)"


End Sub


A next and prev. buttomn would clean up my sheet and make using much
better.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=503365