| 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. |
| 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 | |||
Threaded Mode
