| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Vlookup Function Arguments are correct but nothing in cell | Excel Worksheet Functions | |||
| I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
Hybrid Mode
