Using MATCH function does not return correct answer

I have an application with columns of numbers.

Col A is wave length, B - z are intensities
Row 1 for B - Z contains =MAX(B7:B1201)
Row 2 for B - Z contains =MATCH(B1,B7:B1201,0)
Row 3 for B - Z contains =INDEX($A:$A,B2)

In col B and C the correct row number is returned in row 2, however for the
REST of the columns the row number returned is off by 5 or 6.

Not really sure but I would try
Row 3 for B - Z contains =INDEX($A7:$A1201,B2)
See (to my email, not newsgroup) the file if you wish
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LindaBabe54" <LindaBabe54@discussions.microsoft.com> wrote in message
news:17BE20D7-D4E2-41D9-9DDA-7177865616A3@microsoft.com...
>I have an application with columns of numbers.
>
> Col A is wave length, B - z are intensities
> Row 1 for B - Z contains =MAX(B7:B1201)
> Row 2 for B - Z contains =MATCH(B1,B7:B1201,0)
> Row 3 for B - Z contains =INDEX($A:$A,B2)
>
> In col B and C the correct row number is returned in row 2, however for
> the
> REST of the columns the row number returned is off by 5 or 6.
>

I have the answer. Row 2 should read
Row 2 for B - Z contains =MATCH(B1,B7:B1201,0)+6 to account for the rows
prior to 7. duh


"Bernard Liengme" wrote:

> Not really sure but I would try
> Row 3 for B - Z contains =INDEX($A7:$A1201,B2)
> See (to my email, not newsgroup) the file if you wish
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "LindaBabe54" <LindaBabe54@discussions.microsoft.com> wrote in message
> news:17BE20D7-D4E2-41D9-9DDA-7177865616A3@microsoft.com...
> >I have an application with columns of numbers.
> >
> > Col A is wave length, B - z are intensities
> > Row 1 for B - Z contains =MAX(B7:B1201)
> > Row 2 for B - Z contains =MATCH(B1,B7:B1201,0)
> > Row 3 for B - Z contains =INDEX($A:$A,B2)
> >
> > In col B and C the correct row number is returned in row 2, however for
> > the
> > REST of the columns the row number returned is off by 5 or 6.
> >
>
>
>