Problem with Indexing a specific Row

[Jogier505]

In the attached file I am getting the wrong value in column "V" on sheet 1. Column V refferences the row listed in column "U". Column U is the correct row but for some reason the value returned is the row after the one displayed in column U. Where column U displayes Row 163, I am getting the value for Row 164. Any ideas where the error is?


Jim O

[NBVC]

That's because you are indexing starting at C2 and the Row part of the Index function is row within the range

Try:

=IF($U2="","",INDEX($C$2:$C$1000,$U2-1))

[Cutter]

You are telling it to return the 163rd row of the index but the index starts at row 2, not 1.

So you get row 164

[Jogier505]

Thank you both very much. I knew it had to be something obvious that I was overlooking.

Agaion Thanks!

Jim O