I would use an OFFSET formula.

If I read your formula correctly, the lookup-range is $A$x:$J$x where the row
number, 'x', is contained in B17:

=MATCH(C2,OFFSET($A$1,B17+3,0,10,1))

On Sun, 10 Apr 2005 08:31:02 -0700, "John777"
wrote:

How do I get "=MATCH(C2,ADDRESS(B17+4,1,4,1):ADDRESS(B17+4,10,4 ,1))" to work?