Index formula returning wrong row refferences

[JO505]

For some reason the Index formula is returning rows that are 2 rows off what they should be and I haven't been able to see where the problem lies.

Columns R2 thru U18 are returning values 2 rows off what they should be and I have not had any success in tracking down the problem. I think need some more eyes to help.

Jim O

[Jonmo1]

In R2 you have
=IFERROR(INDEX(Task,$Q3,1),"")

The named range Task refers to
=Sheet3!$I$3:$L$18

Q3 = 15

The 15th Row in I3:L16 is 17

row3 is the 1st row in I3:L18
row4 is the 2nd row in I3:L18
etc..
row 17 is the 15th row in I3:L18

The Row/Column Index #s in INDEX are NOT strictly row/column numbers.
They are POSITION #s, relative to the referenced Range.

Change the named range to
=Sheet3!$I$1:$L$18
or Subtract 2 from Q3

[JO505]

Jonmo1,

Thank you for the help. I changed the reference in the named range as suggested and it works as desired.

I'm chalking this up to MONDAY!!

Thanks again

Jim O

[Jonmo1]

You're welcome.