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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index, match formula
In the MATCH function, match_type (last paramter) should be -1, 0 or 1 and
you have 7! For exact match set to 0. =INDEX('Labor Hours'!B:B,MATCH(B11,'Labor Hours'!A:A,0),1) HTH "Todd" wrote: 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 |
Reply |
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) |