index, match formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top