Index & match function off by one cell

[brooksc29]

=INDEX(MILTM,MATCH(B2,MILP,0),1)

My formula is returning the correct column, however one row below what I need. What am I doing wrong?

 

[circledchicken]

Hi,

I'm guessing its the way you've defined your named ranges.

Perhaps try redefining one of them to the same height as the other, or try adjust the formula to something like:
=INDEX(MILTM, MATCH(B2, MILP, 0) - 1, 1)

 

[JoeMo]

What row do you want and what row does the named range MILP start on?

 

[brooksc29]

yes, it was just that the named ranges were starting one row off each other. thank you!