| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index, match formula
Help, my index formula returns data from the row above the match? What did I
do wrong? =INDEX('Labor Hours'!B:B,MATCH(B11,'Labor Hours'!A:A,7),1) The match is on row B:1214 but the data is pulled from B:1213 instead. Thanks, Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/ Match Formula | Excel Worksheet Functions | |||
| Help with formula statament with a MATCH. | Excel Worksheet Functions | |||
| lookup? Index? match? formula | Excel Discussion (Misc queries) | |||
| Index and Match Array formula | Excel Worksheet Functions | |||
| need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
Threaded Mode
