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.

Using MATCH function does not return correct answer
 

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" wrote in message
...
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.

Using MATCH function does not return correct answer
 

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" wrote in message
...
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.