I've got this formula that works if my lookup range is in ascending order.

=VLOOKUP(A41,INDIRECT("'[Name "& M$25 &" 07Analysis.xls]Overall Top
Ten'!$AA$2:$BJ$401"),MATCH($V$3,INDIRECT("'[Name "& M$25 &"
07Analysis.xls]Overall Top Ten'!$AI$1:$BJ$1"),0)+8)

I need some help modifying this so that I can acheive the same results if
the lookup range is not in order. I think it may involve INDEX and MATCH,
but I'm having a little trouble putting it together.

Can someone assist?

Thank you,
Paul