Using MATCH function does not return correct answer

L

LindaBabe54

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.
 
B

Bernard Liengme

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
 
L

LindaBabe54

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top