I have a list if Employee ID numbers on my sheet named €˜Filtered List. Im
trying to use each of these ID numbers to look up employees on a sheet named
€˜Master. From €˜Master, I want to find the name that is in the same row as
the ID, but in Column C. Then, and finally, I want to take this result, and
match this name to a name in Column B in a sheet named €˜Goals and pick up
the corresponding value that is in the same row.

Im trying this function:
=INDEX(Goals!$C$1:$C$250,MATCH(INDEX(Master!$C$1:$ C$180,MATCH('Filtered
List'!A60,Master!$A$1:$A$180,0)),Master!$C$1:$C$18 0,0))

The results are kind of weird. I cant explain it. I thought I would get a
value which is on row 112, but I actually get a value which is on row 17, and
this result seems completely unrelated to what I wanted. However, over time,
Ive come to realize that if something is incorrect, it is me, and not Excel.
If someone can please point out my error in logic, please post back.

Thanks,
Ryan---


--
RyGuy