Match, Index, Indirect ?
 

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

Match, Index, Indirect ?
 

Ok,

I've got something that appears to be working. This is what I came up with.

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




"PCLIVE" wrote in message
...
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