index, match formula

T

Todd

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
 
T

Toppers

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
 
Top